Discussion board where members can get started with Qlik Sense.
Hi! I guess you have two autoCalendars in the script.
Maybe you unlocked the script and then added data with date fields using the data manager so that QS added second calendar. Try using only one calendar.
have u checked this?
instead of auto calendar u can use the custom below calendar script
remember to update Date field based on your fact table Date field name (or just alias as Date in both place)
Min(FieldValue('Date',RecNo())) as MinDate,
Max(FieldValue('Date',RecNo())) as MaxDate
LET vMinDate = num(Peek('MinDate'));
LET vMaxDate = num(Peek('MaxDate'));
LET vToday = $(vMaxDate);
DROP Table T_MinMax;
LOAD CalDate as Date,
Day(CalDate) as Day,
Week(CalDate) as Week,
WeekDay(CalDate) as WeekDay,
Month(CalDate) as Month,
'Q' & Ceil(Month(CalDate)/3) as Quarter,
Date(MonthStart(CalDate), 'MM-YYYY') as MonthYear,
Week(weekstart(CalDate)) & '-' & WeekYear(CalDate) as WeekYear,
Year(CalDate) as Year,
InMonthToDate(CalDate,$(vToday),0) * -1 as CurrMTDFlag,
InMonthToDate(CalDate,$(vToday),-12) * -1 as LastMTDFlag,
InYearToDate(CalDate,$(vToday),0) * -1 as CurrYTDFlag,
InYearToDate(CalDate,$(vToday),-1) * -1 as LastYTDFlag;
LOAD Date($(vMinDate) + IterNo()) as CalDate
While $(vMinDate) + IterNo() <= $(vMaxDate);
I get the same error when i load the file sent by you.
I am building this app for learning purpose, I don't want this file to be corrected. I want to understand why this error persist and how to solve the issue in future.