Qlik Sense - Calendar Load Script - Weeks starting on Monday

clifford — Mon, 22 May 2023 16:33:44 GMT

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

Re: Qlik Sense - Calendar Load Script - Weeks starting on Monday

Digvijay_Singh — Mon, 22 May 2023 18:08:20 GMT

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

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

topic Re: Qlik Sense - Calendar Load Script - Weeks starting on Monday in App Development

Qlik Sense - Calendar Load Script - Weeks starting on Monday

Re: Qlik Sense - Calendar Load Script - Weeks starting on Monday