Calender Posting Date Problem

vikasmahajan · ‎2014-07-01

Dear all,

Please Find attachement of t.qvw which contains last day of june date with master calender this gives me max(postingdate) as 30/06/2014 date , But while I apply same logic in production environment this shows me date 1/07/2014 , does any body suffer from such issues I attached script also for live.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

rwunderlich · ‎2014-07-02

In the script you posted,

max([Posting Date]) is defined by the SQL statement:

SQL SELECT MaxDate

FROM "QLIKVIEW_SIM_DB".dbo.MAXDT;

Is 1/7/2014 what is returned in production?

-Rob

vikasmahajan · ‎2014-07-02

Rob Sir,

It Returns 30/06/2014 end of the month . But when I implement the same in live with link tables it takes max(postingdata) 01/07/2014 date.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2014-07-02

Sir,

I found there are collections entry passed in 01/07/2014 date and I thing via Link table max(posting date) might be a 1/7/2014.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

QlikView App Dev