Use chart dimension as value in set expression

Anonymous — Wed, 26 Oct 2016 03:42:36 GMT

Hi All,

I am trying to create a Chart for Renewal Rate based on 3 dimensions: Revenue, Year, Expiry_Year but the calculation of Renewal Rate would only be based on Expiry_Year and Revenue

I have a list box that allows me to select Expiry_Year from 2010 - 2017. If I select both 2015 and 2016, I would like to create a Chart as follows:

Year	Renewal Rate
2015	calc based on Expiry_Year = 2015
2016	calc based on Expiry_Year = 2016

The expression I was using is sum( {<Expiry_Year=p(Year)>}Revenue) ,which isn't returning the expected results.

How do I create a Set expression that uses the current Year i.e. current row in the chart, for the Expiry_Year = {} value?

Thanks in advance.

topic Use chart dimension as value in set expression in QlikView

Use chart dimension as value in set expression