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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
MVP
MVP

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...