Announcements
cancel
Showing results for
Did you mean:
Partner - Creator III

## 4-5-4 retail calendar

Dear community,

I need help with a tricky task.

The user should have the possibility to switch between a predefined fiscal calendar and a 4-5-4 NRF retail calendar.

The fiscal calendar is working fine, using Fiscal Year from hic

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.

e.g.

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.

Best regards,

Ronny

7 Replies
Partner - Creator III
Author

Hi all,

did someone maybe know if this data is available online in a format that can be load directly into QV ?

I'm trying now to create a logic from the existing fiscal calendar and shift the week numbers but not sure if this will work.

Best regards,

Ronny

MVP

Maybe like this, please find attached.

Partner - Creator III
Author

Hi swuehl,

I will check it and let you know if I can make it work in my application.

Best regards,

Ronny

Partner - Contributor III

Hello Ronny,

Have you found a solution for the retail calendar?

I have the same problem with the 544 calendar.

In the example posted: Mastercalendar_Community_Retail.qvw

i don't understand this variable.

Set vCal_RD = 34; // Reference day = This day in Jan defines week one {1..7}

Reference day of which year?

For year 2016, the 1 week start 4 jan; for year 2015, the 1 week start 29 dec...

Regards

Manuele

Partner - Creator III
Author

Hi Manuele,

Yes, finally it worked.

I just need to check my old data. I will let you know as soon as possible.

Best regards,

Ronny

I think this is helpful: 4-5-4 Master Calendar.

- Marcus

Partner - Contributor III

Many thanks to swuehl! This helped me a lot!

Community Browser