
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Four Month Periods on Autocalendar Qlik Sense
Hi everybody,
Simple question,
I know I can get year, 3 months periods, year quarter from a date using autocalendar as I show you below.
[autoCalendar]:
DECLARE FIELD DEFINITION Tagged ('$date')
FIELDS
Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),
Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter', '$cyclic'),
Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$yearquarter','$qualified'),
DERIVE FIELDS FROM FIELDS [tsContact] USING [autoCalendar] ;
But I couldn´t achieve a four months periods inside Qlik Sense.
Please anyone who knows the exact code to create 4 months periods from a date using autocalender to divide the year in three parts instead of 4.
Thank you in advance


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If
Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter],
delivers quarters, then something like
Dual('F'&Num(Ceil(Num(Month($1))/4)),Num(Ceil(NUM(Month($1))/4),00)) AS [FourMonthPeriod],
delivers four month periods, right?
hope this helps
Marco

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marco,
Thank you for your reply.
I don´t specify that I also try to make the Year-FourMonthPeriod.
As you can see here I didn´t achieve it, it takes properly the fourmonthperiod, but for a reason I don´t understand it doesn´t take properly the year.
This is the code I use to try to create the Year_FourMonthPeriod
Dual(Year($1)&'-C'&Num(Ceil(Num(Month($1))/4)),Num(Ceil(NUM(Month($1))/4),00)) AS [YearCuatrimestre] Tagged ('$YearCuatrimestre', '$qualified'),
