Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Be sure to refer to the documentation for the Week function. There are 2 settings that you can manipulate to define when your first week should start. https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...
Below you will see that by default if I just ask for the Week Friday January 1 is in the first week, but Tuesday January 5 (first full week) is actually week 2 because of the way the previous week ended.
In the last column though you can see see that if I say the weeks should start on Monday and that I want to use Unbroken weeks) it keeps 1/1 in the 53rd week of 2020 since I don't want weeks to be broken. And then April 5 is in week 14 as you desire.
If you don't like the default way the AutoCalendar works you can change it by manipulating the two flags as needed for your environment.
Be sure to refer to the documentation for the Week function. There are 2 settings that you can manipulate to define when your first week should start. https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...
Below you will see that by default if I just ask for the Week Friday January 1 is in the first week, but Tuesday January 5 (first full week) is actually week 2 because of the way the previous week ended.
In the last column though you can see see that if I say the weeks should start on Monday and that I want to use Unbroken weeks) it keeps 1/1 in the 53rd week of 2020 since I don't want weeks to be broken. And then April 5 is in week 14 as you desire.
If you don't like the default way the AutoCalendar works you can change it by manipulating the two flags as needed for your environment.
