topic Re: Calender Posting Date Problem in QlikView

Calender Posting Date Problem

vikasmahajan — Wed, 02 Jul 2014 03:11:30 GMT

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

Re: Calender Posting Date Problem

rwunderlich — Wed, 02 Jul 2014 04:12:09 GMT

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

Re: Calender Posting Date Problem

vikasmahajan — Wed, 02 Jul 2014 04:50:16 GMT

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

Re: Calender Posting Date Problem

vikasmahajan — Wed, 02 Jul 2014 05:24:56 GMT

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