topic Problem creating Calendar in QlikView

Problem creating Calendar

Mon, 19 Dec 2011 11:19:22 GMT

Hello,

can anyone tell me why this is wrong?

LET EndCalendar = YearEnd(today());

LET StartCalendar= '01.01.' & (Year(today())-1);

LOAD Date($(StartCalendar) + rowno() -1) as TempDate

AutoGenerate $(EndCalendar) - $(StartCalendar) + 1;

I am getting a mistake debugging and I can't see why

Regards and thanks in advance!

Stef

Mon, 19 Dec 2011 11:20:23 GMT

PD: I am trying to create a calendar that contains the dates from the 1. January from last year until the 31. December of the current year..

vijay_iitkgp — Mon, 19 Dec 2011 11:38:11 GMT

Hi Stef,

please use following script:

LET EndCalendar = Num(YearEnd(today()));

LET StartCalendar=Num(makedate((Year(today())-1),'01','01'));

LOAD Date($(StartCalendar) + RecNo() -1) as TempDate

AutoGenerate($(EndCalendar) - $(StartCalendar) + 1);

Regards

Vijay