Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi Everyone ,
i am getting the "Field '<=' not found" error while loading the Master calendar script.
below is the script what i am running
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
min(UPDATEDATE) as minDate, //UPDATEDATE is the name of the date field which i have and it in YYYY/MM/DD formate
max(UPDATEDATE) as maxDate
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
$(varMinDate) + ITERNO()-1 As Num,
DATE($(varMinDate) + ITERNO() - 1) as TempDate
AUTOGENERATE 1 WHILE $(varMinDate) + ITERNO() -1 <= $(varMaxDate);
TempDate AS UPDATEDATE,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
YeartoDate(TempDate)*-1 as CurYTDFlag,
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,
ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
Order By TempDate ASC;
Drop Table TempCalendar;
Check if the variables are getting the correct values.
The error is occurring while loading the TempCalendar Last statement, where it is not getting value for the Max Variable.
I agree with Kaushik. You can validate the values of variables and do the needful.
thanks and the reason for the error is Date format of m date field is YYYYMMDD, so Temp table nit fetching the the min and max dates from the date field.
i converted the date format in to DD/MM/YYYY and then its working fine.