Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to create one master calendar with 5-4-4 weeks the given below: For every quarter of the first month should have 5 weeks based on the start date and end date.
Start Date for the Month | End Date for the Month | Financial Year | Quarter# | Month# |
28-09-2020 | 01-11-2020 | FY2020-21 | 1 | 1 |
02-11-2020 | 29-11-2020 | FY2020-21 | 1 | 2 |
30-11-2020 | 27-12-2020 | FY2020-21 | 1 | 3 |
28-12-2020 | 31-01-2021 | FY2020-21 | 2 | 4 |
01-02-2021 | 28-02-2021 | FY2020-21 | 2 | 5 |
01-03-2021 | 28-03-2021 | FY2020-21 | 2 | 6 |
29-03-2021 | 02-05-2021 | FY2020-21 | 3 | 7 |
03-05-2021 | 30-05-2021 | FY2020-21 | 3 | 8 |
31-05-2021 | 27-06-2021 | FY2020-21 | 3 | 9 |
28-06-2021 | 01-08-2021 | FY2020-21 | 4 | 10 |
02-08-2021 | 29-08-2021 | FY2020-21 | 4 | 11 |
30-08-2021 | 26-09-2021 | FY2020-21 | 4 | 12 |
Kindly help me to create this.
Thanks in advance.
Regards,
Dinesh Kumar Mani.
Hi, googling it I found this: https://community.qlik.com/t5/Documents/Calendars/ta-p/1496392
Ther is an attachment with diffrerent calendars, look for the 5-4-4