Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

Adding Fiscal Year and Quarter to existing Calendar

MasterCalendar:
Load
TempDate AS CreatedOn,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
'Q' & ceil(month(TempDate) / 3) AS Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
;

//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;

//=== Get min/max dates from Field ===/
LOAD
min(FieldValue('CreatedOn', recno()))-1 as mindate,
max(FieldValue('CreatedOn', recno())) as maxdate
AUTOGENERATE FieldValueCount('CreatedOn');

 

Hi, what changes can be made to above code to add Fiscal Year and Quarter into this.

Thanks & Regards,
Please Accepts as Solution if it solves your query.
0 Replies