topic Previous year set analysis in QlikView

Previous year set analysis

Wed, 11 Jul 2012 15:01:49 GMT

I am trying to use set analysis to do a year on year comparison using the below. This works on a normal year eg 2012 but our financial year is 2012/13.

Does anyone know how i can get the previous year so 2011/12?

=Only (JOINERCalendar.FinancialYear - 1)

Thanks

Manisha

Re: Previous year set analysis

MayilVahanan — Wed, 11 Jul 2012 15:10:20 GMT

Hi,

Try this,

=Date(AddMonths(Date#('2012/12','YYYY/MM'),-12) ,'YYYY/MM')

gives 2011/11

Hope it helps

Re: Previous year set analysis

Wed, 11 Jul 2012 15:19:33 GMT

Hi Mayil

Thanks for your quick response the financial year can be selected so i changed your code to the below:

=Date(AddMonths(Date#(JOINERCalendar.FinancialYear,'YYYY/MM'),-12) ,'YYYY/MM')

however if i have 2011/12 selected then the previous year shows as 2010/12 instead of 2010/11?

Regards

Manisha

Re: Previous year set analysis

v_iyyappan — Wed, 11 Jul 2012 15:20:49 GMT

Hi,

Use like this in dynamic date

= Date(AddMonths(Today(),-12) ,'YYYY/MM') you will get the 2011 / 07 where Today() replace of your datefield.

= Date(AddMonths(Date#('2012/12','YYYY/MM'),-13) ,'YYYY/MM') you will get 2011/ 11

Hope its help

Regards,

Iyyappan.