Discussion Board for collaboration related to Creating Analytics for QlikView.
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!
Go to Solution.
please use following script:
LET EndCalendar = Num(YearEnd(today()));
LOAD Date($(StartCalendar) + RecNo() -1) as TempDate
AutoGenerate($(EndCalendar) - $(StartCalendar) + 1);
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..