Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

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

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

7 Replies
Partner
Partner

Re: 4-5-4 retail calendar

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

MVP
MVP

Re: 4-5-4 retail calendar

Maybe like this, please find attached.

Partner
Partner

Re: 4-5-4 retail calendar

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

Highlighted
Partner
Partner

Re: 4-5-4 retail calendar

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

Partner
Partner

Re: 4-5-4 retail calendar

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

MVP & Luminary
MVP & Luminary

Re: 4-5-4 retail calendar

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

- Marcus

Partner
Partner

Re: 4-5-4 retail calendar

Many thanks to swuehl! This helped me a lot!