Current vs. Previous Fiscal Year Expression

danielle_v — Mon, 28 Jul 2014 11:05:37 GMT

Hi All,

I am doing some analysis using a fiscal calendar where the years are formatted as 2013/2014, 2014/2015 etc. These have been loaded into the script using the dual function, so each fiscal year also has a numeric value.

With a little help from the Qlikview community, I have managed to create some variables for the years to be used for labelling, these are;

vCurrentYear = Cal_FiscalYear

vPreviousYear = num(left(MaxString(Cal_FiscalYear),4)-1)&'/'&num(right(MaxString(Cal_FiscalYear),4)-1,'00')

However, my issue now is that I'm struggling to do any calculations based on current year and previous year (I want to look at volume for the selected year vs. volume for selected year minus 1) . My variables don't seem to work in calculations, and I've tried all sorts of set analysis but can't seem to get anythgin to work. I seemt o be able to get the selected year calculation to work ok, but can't get any set analysis around year-1 to bring back any data.

Any guidance much appreciated!

Re: Current vs. Previous Fiscal Year Expression

c_gilbert — Mon, 28 Jul 2014 11:09:44 GMT

This is the set analysis we use for the previous year:

=Sum ({$<Year_Fiscal = {'$(vPreviousFiscalYear)'} >}

[Op Activity Count]

)

Re: Current vs. Previous Fiscal Year Expression

danielle_v — Tue, 29 Jul 2014 08:50:45 GMT

Worked perfectly... many thanks for helping me out again!!

Re: Current vs. Previous Fiscal Year Expression

c_gilbert — Tue, 29 Jul 2014 08:55:48 GMT

No problem, happy to help

topic Re: Current vs. Previous Fiscal Year Expression in QlikView

Current vs. Previous Fiscal Year Expression

Re: Current vs. Previous Fiscal Year Expression

Re: Current vs. Previous Fiscal Year Expression

Re: Current vs. Previous Fiscal Year Expression