So we recently updated from the May 2022 version of Qlik Enterprise for Windows to Feburary 2023 version and since we've updated a ton of our KPIs and Master Dimensions have stopped working. We have managed to isolate the issue to our fiscal calendar generation which can be seen below:
LET vFM= 4;
[Fisc]:
DECLARE FIELD DEFINITION Tagged ('$date')
FIELDS
Dual('20'&Right(YearStart($1,0,vFM),2)&'/'&(Right(YearStart($1,0,vFM),2)+1), YearStart($1,0,vFM)) AS [Year] Tagged ('$axis', '$year'),
Dual('Q'&Num(Ceil(Num(Month(AddMonths($1,1-vFM)))/3)),Num(Ceil(NUM(Month(AddMonths($1,1-vFM)))/3),00)) AS [Quarter] Tagged ('$quarter', '$cyclic'),
Dual('20'&Right(YearStart($1,0,vFM),2)&'/'&(Right(YearStart($1,0,vFM),2)+1)&' - Q'&Num(Ceil(Num(Month(AddMonths($1,1-vFM)))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$yearquarter', '$qualified'),
Dual('Q'&Num(Ceil(Num(Month(AddMonths($1,0,1-vFM)))/3)),QuarterStart($1)) AS [_YearQuarter] Tagged ('$yearquarter', '$hidden', '$simplified'),
Dual(Month($1), Month($1)) AS [Month] Tagged ('$month', '$cyclic'),
Dual('20'&Right(YearStart($1,0,vFM),2)&'/'&(Right(YearStart($1,0,vFM),2)+1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth', '$qualified'),
Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden'),
Date(Floor($1)) AS [Date] Tagged ('$axis', '$date', '$qualified'),
Date(Floor($1), 'D') AS [_Date] Tagged ('$axis', '$date', '$hidden', '$simplified');
Now anything that uses the fisc version of the date field says error in expression but the autocalendar seems to work, we have also found replacing the vFM variable and hardcoding 4 into the data load editor fixes the issues so just wondering if anyone knows if anything has changed in the way that the data load editor handles variables.
Hi,
Implement this simple code for calendar we have fiscal year created in the script.
https://community.qlik.com/t5/Member-Articles/SIMPLE-MASTER-CALENDER/ta-p/1484974
Vikas
Hello @McQlikkityQlikFace,
Thanks for posting.
Do you have the script that you were using before?
Cheers,
Albert