4-5-4 retail calendar

[r_wroblewski]

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

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.

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

[r_wroblewski]

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.

If someone has an idea or advice please let me know.

Best regards,

Ronny

[swuehl]

Maybe like this, please find attached.

[r_wroblewski]

Hi swuehl,

many thanks for your reply.

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

Best regards,

Ronny

[manuele_silvest]

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...

Thanks in advance

Regards

Manuele

[r_wroblewski]

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

[marcus_sommer]

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

- Marcus

[t_witzgall]

Many thanks to swuehl! This helped me a lot!