Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vikasmahajan
Esteemed Contributor

Calender Posting Date Problem

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

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Calender Posting Date Problem

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
Esteemed Contributor

Re: Calender Posting Date Problem

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

vikasmahajan
Esteemed Contributor

Re: Calender Posting Date Problem

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