WEEK starts on thursday and end in wednesday. i have a problem on sorting the date from january to december

[ejriri]

I need help. I have a bar graph. my week should start on thursday and ends in wedensday. so i use this formula,

=Date([Estimated Start Date] - WeekDay([Estimated Start Date], 3), 'MMM-DD') & ' - ' & Date([Estimated Start Date] - WeekDay([Estimated Start Date], 3) + 6, 'MMM-DD')

the problem is i cant sort the date from january to december.

please help me.

[Clement15]

Hello,

Thursday is said to be the first day only for this chart or for the whole application?
If it is for the whole application you can simply change the 'set FirstWeekDay =' in the main.
https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInterpret...