Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
r_wroblewski
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
r_wroblewski
Partner
Partner
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.

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

Best regards,

Ronny

swuehl
MVP
MVP

Maybe like this, please find attached.

r_wroblewski
Partner
Partner
Author

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

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

t_witzgall
Partner
Partner

Many thanks to swuehl! This helped me a lot!