1 Reply Latest reply: May 25, 2017 3:43 AM by Tomasz Truszkowski RSS

    Redefining week numbers in Sense

    Michael Markham

      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}