topic Re: 4-5-4 retail calendar in QlikView

4-5-4 retail calendar

r_wroblewski — Thu, 25 Jun 2015 09:30:27 GMT

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

Re: 4-5-4 retail calendar

r_wroblewski — Fri, 26 Jun 2015 01:24:25 GMT

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

Re: 4-5-4 retail calendar

swuehl — Fri, 26 Jun 2015 07:23:52 GMT

Maybe like this, please find attached.

Re: 4-5-4 retail calendar

r_wroblewski — Fri, 26 Jun 2015 07:55:30 GMT

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

Re: 4-5-4 retail calendar

manuele_silvest — Fri, 26 Feb 2016 14:59:23 GMT

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

Re: 4-5-4 retail calendar

r_wroblewski — Mon, 29 Feb 2016 07:01:36 GMT

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

Re: 4-5-4 retail calendar

marcus_sommer — Mon, 29 Feb 2016 08:20:51 GMT

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

- Marcus

Re: 4-5-4 retail calendar

t_witzgall — Fri, 11 Mar 2016 13:42:02 GMT

Many thanks to swuehl! This helped me a lot!