How to create a financial year calander in Qlikview

[#1]

I have to create a financial year calander starting from 2001 April to 2010 March

Financial Year begning April and ending March

Q1 -> Aprio- June

Q2 -> July - Sep

Q3 -> Oct -Dec

Q4 -> Jan- March

Any help would be appreciated.

Thanks,

Divya

[johnw]

Maybe this?

[Financial Calendar]:
LOAD *
,dual('Q' & if(month(Date)<4,4,floor(month(Date)/3)) & ' ' & FinancialYear,quarterstart(Date)) as FinancialQuarter
;
LOAD *
,date(yearstart(Date,0,4),'YYYY') as FinancialYear
;
LOAD date(date#(20010331,'YYYYMMDD')+recno()) as Date
AUTOGENERATE today()-date#(20010331,'YYYYMMDD')
;

[#3]

Hi John

With this solution will I be able to work out total amounts based on this financial period (April - March)?  Reason being I also have a similar problem and would like a solution that will assist in working out figures for the whole financial period and YTD figures working from April.