KPI for % change over two dimensions

[raivalen]

Hi.

I need to insert on my QlikSense Analytics app a KPI that shows the percentage of change between two years with the below data. How can I show the % of change when I select 2 years as dimension filter? 

 

[Sayed_Mannan]

if you want to select two different year then you can use alternative dimension here.

but if you want to see %change based on selected year vs last year then see the below expression:-

Num(
(Sum({<Year = {"$(=Max(Year))"}>} Sales) - Sum({<Year = {"$(=Max(Year)-1)"}>} Sales)) /
Sum({<Year = {"$(=Max(Year)-1)"}>} Sales),
'#,##0.00%'
)

I hope this helps.