Qlik AutoCalendar week return wrong value

katarzyna00001 — Tue, 11 May 2021 07:46:47 GMT

In stead od W14 autocalendar display W15.

Re: Qlik AutoCalendar week return wrong value

Dalton_Ruer — Tue, 11 May 2021 13:21:19 GMT

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/DateAndTimeFunctions/week.htm

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.

topic Qlik AutoCalendar week return wrong value in App Development

Qlik AutoCalendar week return wrong value

Re: Qlik AutoCalendar week return wrong value