Create Financial Calendar

Fri, 18 Nov 2011 14:43:19 GMT

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

Re: Create Financial Calendar

johnw — Fri, 18 Nov 2011 22:18:35 GMT

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.

topic Create Financial Calendar in QlikView

Create Financial Calendar

Re: Create Financial Calendar