Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
clifford
Contributor II
Contributor II

Qlik Sense - Calendar Load Script - Weeks starting on Monday

I have a Calendar in my load script that has been edited to start weeks on Monday. This script:

Dual(Year($1), YearStart($1))&'-'&Dual('W'&Num(Week($1,0),00), Num(Week($1,0),00)) as [YearWeek];

Is outputting the 1st week of 2023 as a week only containing the day 1/1/23. How can I change it to make the first week of 2023 to start on the first Monday of this year, 1/2/23?

Thank you

Labels (1)
1 Reply
Digvijay_Singh

I see one parameter named broken_weeks in the week function if it can help you in some way - 

Digvijay_Singh_2-1684778870821.png

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...