Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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...