Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community, I am new to Qlik Sense and have just created my first App . I have just realised my week numbers are not defined to IOS 8601 with week 1 containing the 4th. I have followed the online instruction in setting the reference day to 4 in the syntax. I reload the app but it does not change the weeks.
Am I missing a step?
https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers#start=25
Set vCal_FD = 0; // First Day of the week {0=Mon, 1=Tue, ... , 6=Sun}
Set vCal_BW = 0; // Broken Weeks allowed {0=No, 1=Yes}
Set vCal_RD = 4; // Reference day = This day in Jan defines week one {1..7}
You can change system variables in auto-generated section of the script:
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
kind regards,
Tomasz