
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Adapting a fiscal calendar to the new Qlik Sense auto calendar code
If you had a fiscal calendar, say, your year starts on 28th of December, 2015 and ends on 25th of December, 2016. How are you going to incorporate that into the qlik sense auto calendar? And make sure the months, week and quarters correspond too. I would think the "Addmonth" and "Makedate" functions could be used, but I have not been successful in using those. Any help, insights or ideas?
Table with Fiscal calendar
Begin Date | Week Number | Month Number | Quarter Numb | Year |
---|---|---|---|---|
12/28/2015 | 1 | 1 | 1 | 2016 |
1/25/2016 | 5 | 2 | 1 | 2016 |
2/29/2016 | 10 | 3 | 1 | 2016 |
3/28/2016 | 14 | 4 | 2 | 2016 |
4/25/2016 | 18 | 5 | 2 | 2016 |
5/23/2016 | 22 | 6 | 2 | 2016 |
6/27/2016 | 27 | 7 | 3 | 2016 |
7/25/2016 | 31 | 8 | 3 | 2016 |
8/29/2016 | 36 | 9 | 3 | 2016 |
9/26/2016 | 40 | 10 | 4 | 2016 |
10/24/2016 | 44 | 11 | 4 | 2016 |
11/28/2016 | 49 | 12 | 4 | 2016 |
12/26/2016 | 1 | 1 | 1 | 2017 |
Auto Calendar Code:
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'),
Dual('Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [_YearQuarter] Tagged ('$yearquarter', '$hidden', '$simplified'),
Month($1) AS [Month] Tagged ('$month', '$cyclic'),
Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth', '$qualified'),
Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden'),
Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber', '$cyclic'),
Date(Floor($1)) AS [Date] Tagged ('$axis', '$date', '$qualified'),
Date(Floor($1), 'D') AS [_Date] Tagged ('$axis', '$date', '$hidden', '$simplified');
DERIVE FIELDS FROM FIELDS [StartDate] USING [autoCalendar] ;
I am new to qliksense, so pardon me.I attached a file with the full length of the calendar if needed.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am having the same problem. My fiscal year starts in October so while the auto calendar is great I really can't use quarters since they are for the regular year. I've tried using the FirstMonthOfYear function but was not successful.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Similar issue here too. You'd think it was about time that this Fiscal Calendar requirement became a standard feature / function within the Qlik Sense tool set, especially for Enterprise analysis. In its simplest form I would have thought that an 'Auto Fiscal Calendar' capability could be available, perhaps just set the start of the fiscal year and the remaining Fiscal Calendar Measures are created?
Can you imagine a world were:
[FiscalYear] [FiscalQuarter]
[FiscalYearQuarter] [FiscalMonth]
[FiscalYearMonth] [FiscalWeek]
[InFiscalYTD] [FiscalYearsAgo]
[InFiscalQTD] [FiscalQuartersAgo]
[InFiscalMTD] [FiscalMonthsAgo]
[InFiscalWTD] [FiscalWeeksAgo]
are just a parameter or two away, no, just me?
