Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?