Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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