but I don't know where to start with the 4-5-4 calendar.
After investigating the basic rules
1 Quarter = 4 weeks - 5 weeks - 4 weeks
(52weeks x 7days = 364days)
53 weeks if , after laying out the entire 52-week calendar for any given year, there are four or more days left in January during the 53rd week, then a 53rd week is added. (https://nrf.com/resources/4-5-4-calendar)
What I try to achieve:
Week start for 4-5-4 calendar should be monday, same like fiscal calendar.
4-5-4 calendar year-week week start week end total weeks
2012-1 (FEB) 2012/01/30 2012/02/05 53
2013-1 (FEB) 2013/02/04 2013/02/10 52
2014-1 (FEB) 2014/02/03 2014/02/09 52
2015-1 (FEB) 2015/02/02 2015/02/08 52
Did someone has experience with implementation of such a 4-5-4 retail calendar in QlikView and can advise me?
Please feel free to use attached qvw, which already include default & fiscal calendar.