Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Financial Calendar

How can I create a Financial Calendar till the current Financial year

1 Reply
johnw
Champion III
Champion III

Pretty much the same way you create any calendar.  Load in your dates, possibly using an autogenerate, then establish other fields from them.  For instance, let's say your date field was "Date", and your financial year starts on April 1.  You might do this:

[Calendar]:
LOAD *
,date(yearstart("Date",0,4),'YYYY') as "Financial Year"
;
LOAD date(fieldvalue('Date',recno())) as "Date"
AUTOGENERATE fieldvaluecount('Date')
;

I suspect there are plenty of other examples on the forum if you search.