Comparing Data by months and Fiscal Year

nwilliams — Fri, 20 Nov 2015 12:04:42 GMT

Hi,

I'm trying to create a chart that shows 24 months of data, but only compares the last 2 Fiscal years.

I'm using set analysis in my expression to pull back the previous 24 months work of data based on the month selected. Now I want 1 expression for the current FY, and one for the previous FY.

I've currently manually put this in simply by adding "Calendar.UKFYYear = {'FY15'}" to the expression, and this works fine.

However, I want to make this maintenance free, and want the "FY15" bit to be calculated based on the month selected.

I have attached the QVW file so you can see what I'm doing. The expression I'm using is:

=sum({<
Calendar.MonthName = {">=$(=Addmonths(Max(Calendar.MonthName),-24)) <=$(=Max(Calendar.MonthName))"},
Calendar.UKFYYear = {'FY15'}
>}Sent)

Any thoughts on how this can be done would be grateful, as I've been playing with this for some time and had no luck.

topic Comparing Data by months and Fiscal Year in QlikView

Comparing Data by months and Fiscal Year