topic How to create a financial year calander in Qlikview in QlikView

How to create a financial year calander in Qlikview

Wed, 24 Mar 2010 13:32:12 GMT

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

How to create a financial year calander in Qlikview

johnw — Wed, 24 Mar 2010 21:08:51 GMT

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')
;

Re: How to create a financial year calander in Qlikview

Mon, 02 Dec 2013 14:50:46 GMT

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.