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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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...