Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

How to convert 4-5-4 calendar to Normal Calendar

Hi,

We have 4-5-4 retail calendar, how to convert this calendar to normal calendar?

Thanks,

5 Replies
Not applicable

Re: How to convert 4-5-4 calendar to Normal Calendar

Hi,

I hope some one has worked on this scenario, can you please help me here.

Thanks,

rupamjyotidas
Valued Contributor

Re: How to convert 4-5-4 calendar to Normal Calendar

Try this solution

Canonical Date

mov
Esteemed Contributor III

Re: How to convert 4-5-4 calendar to Normal Calendar

The specific of the 4-5-4 calendar is that it uses retail periods, more or less approximate to months, with length of 4 weeks, 5 weeks, and 4 weeks in each retail quarter.  So, you need to use "normal" months and quarters instead of the retail periods.  If you have Date field, the Month-Year will be:

Date(monthstart(Date), 'MMM-YYYY') as MonthYear

Quarter:

'Q' & ceil(month(Date)/3) & '-' & year(Date)

MVP & Luminary
MVP & Luminary

Re: How to convert 4-5-4 calendar to Normal Calendar

This one: 4-5-4 Master Calendar is the opposite and I think you could reverse the logic and/or use them as mapping to your calendar.

- Marcus

Not applicable

Re: How to convert 4-5-4 calendar to Normal Calendar

Hi,

Thanks for your valuable posts, I got it.

Thanks,