Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Comparing Data by months and Fiscal Year



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:


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

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.


0 Replies