Need to create Master Calendar

[Buchannagari]

Hi ,

That image is SAP data calendar , i want to create same calendar in Qlik sense .

and the requirement is they want data from 01/01/2022 to 
01/01/2050

LOAD * INLINE [
Date
01/01/2022
01/01/2050
];

I have created master calendar but weeks are not coming like SAP calendar

from SAP calendar 1st week  started from 3rd but in qlik 1st week stared from 1st january 2022

so , data is not correct for the selection.

can anyone please help me how to get it in Qlik

Regards,

Buchanangari.

[vinieme12 · Accepted solution]

SAP is using ISO Weeks, unbroken weeks

The reason your week 1 is starting from 1st January is because this variable is set to 1;

SET BROKENWEEKS = 1; 

You can either change this to 0

OR

specify to use unbroken weeks in your calendar script as below

,Week(tempDate,0,0,4)  as  Week

Refer this

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...