topic Re: Current Financial Year in calculated expression in QlikView

Current Financial Year in calculated expression

helen_pip — Fri, 16 Aug 2013 08:10:48 GMT

Hello

Could someone kindly help me write the current financial year for the following calculated dimension

I have Current_Quarter (By number) available

I have Run_Month (By Number) available

I have Month_Year field (Apr-2013) available

if(InYear( CWT_Monthly_desc_Report.desc_month_Year, Today(),0), date(CWT_Monthly_desc_Report.desc_month_Year

,'MMM YYYY'))

My financial year runs from Apr-Mar

Is this possible with the above fields?

Kind Regards

Helen

tresB — Fri, 16 Aug 2013 08:21:25 GMT

you can try this:

=Year(Month_Year) + If(Run_Month>=4, 1, 0)

helen_pip — Fri, 16 Aug 2013 08:25:24 GMT

Hello

Thank you for this suggestion

This is great as it gives me a bar for 2012,2013 and 2014

However what I wanted to achieve was the months for current FY I.e. April 2013, May 2013, June 2013 etc

Could you kidnly help me achive this too?

Kind Regards

Helen

tresB — Fri, 16 Aug 2013 09:11:27 GMT

Your requirement is not very clear to me, can you please explain a bit like 'i have AAA and i want the output against that is BBB' ?