Redefining week numbers in Sense

Wed, 17 May 2017 23:56:22 GMT

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}

Re: Redefining week numbers in Sense

tomasz_tru — Thu, 25 May 2017 07:43:41 GMT

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

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

kind regards,

Tomasz

topic Re: Redefining week numbers in Sense in App Development

Redefining week numbers in Sense

Re: Redefining week numbers in Sense