Hello, I’m looking for some assistance please with the Calendar that is used on QlikView. It’s the Master Calendar that affects all our production QVDs so I’m afraid to make too many changes to it.
My colleague who looked after the calendar at Year End has left the company and I’m still relatively new in the role and feeling some pressure to resolve 😊
What is happening is that Fiscal Week 1 2021 is showing as Fiscal Week 53 2021.
I need to split out the weeks, however, they are currently showing as below:
- Fiscal Week 52 2020 –> 19/12/2020 – 25/12/2020
- Fiscal Week 53 2020 -> 26/12/2020 – 29/12/2020 (Year End 29/12/2020)
- Fiscal Week 53 2021 -> 30/12/2020 – 01/01/2021 (This needs to be Fiscal Week 1 2021)
- Fiscal Week 2 2021 -> 02/01/2021 – 08/01/2021
This is the way the calendar is showing at the moment for Jan 2021:
Fiscal Week 2021-53 is showing the below dates:
Fiscal Week 1 is showing from 02/01/2021 to 08/01/2021 – so essentially looking to remove the Fiscal Week 2021-53 and have it as Fiscal Week 1 and the current Fiscal Week 1 becomes Fiscal Week 2.
I’ve attached the calendar script (with some data removed) we currently have so any guidance or assistance would be appreciated.