Discussion board where members can get started with Qlik Sense.
I'm trying to make master calendar for reports.
Min date must be hard coded 20140101 and Max today + 1825 days
This is what I have:
Let vMinDate = Num(DATE('20140101');
Let vMaxDate = Num(DATE(Today()+1825);
$(vMinDate)+IterNo()-1 as Num
AUTOGENERATE 1 WHILE $(vMinDate)+IterNo()-1<= $(vMaxDate);
num(floor(Num)) as Date,
Week(Num) as Week,
Year(Num) as Year,
Month(Num) as Month,
Num(Month(Num)) as MonthNo,
Day(Num) as Day,
Weekday(Num) as WeekDay,
Ceil(month(Num)/3) AS Quarter,
Year(Num)&'-'& Week(Num) as YearWeek
Drop Tables TempCalendar;
Problem appears when I'm loading data:
The following error occurred:
Field '<=' not found
The error occurred here:
Data has not been loaded. Please correct the error and try loading again.
Do you know what might be reason?
Let vMinDate = Num(DATE(makedate(2014,01,01)));
Let vMaxDate = Num(DATE(num(Today())+1825));
It works. Thank you!