topic Script distinct date + append 12 coming month in QlikView

Script distinct date + append 12 coming month

Mon, 14 Mar 2011 03:34:48 GMT

Hello,

I want to retrieve all distinct dates (all in format MMM YYYY, using MonthName function) from my fact table and then append them by the next coming 12 months, here is my script but it is not working. Any suggestion

tmp:
Load Distinct OpenMonth as newDate
Resident Fact;
CONCATENATE (tmp)
LOAD
MonthName(Max(OpenMonth),IterNo()) as newDate
RESIDENT Fact
while MonthName(Max(OpenMonth),IterNo()) <= MonthName(Today(),12)
;

Script distinct date + append 12 coming month

Mon, 14 Mar 2011 05:12:42 GMT

hi n.allano ,

Update your While Condicion as like below..

while num(Max(OpenMonth)) <= num(addmonths(date(Today()),12));

i think it will work....

Regards

A'run'

Script distinct date + append 12 coming month

Tue, 15 Mar 2011 06:24:11 GMT

Yes, you are right. I understood that when I use < > to compare dates, I need to take their numeric values. However, the solution is still not working