Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Redefining week numbers in Sense

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}

1 Reply
tomasz_tru
Specialist
Specialist

You can change system variables in auto-generated section of the script:

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

kind regards,

Tomasz