Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me with this please. I am new to Qlik and trying to show a KPI in the app. The KPI should be a calculated to show the % change of the sales price of a specific asset over a period of 2 years. The Change is to be calculated in %. I am providing an example data so that it is clear on what i am trying to do.
Asset | Jan-14 | Aug-14 | Jan-15 | Aug-15 | Jan-16 | Jun-16 |
Area 10 | 2000 | 1950 | 1920 | 1910 | 1900 | 1880 |
I am trying to show a % difference for the asset in Area 10 from 1) June 2016 to Jan 2014 2) June 2016 to Aug 2014 3) Jun 2016 to Aug 2015 in three seperate KPI boxes.
Can someone help me with the formula i need to enter for this specific KPI.
Thank you so much.
Vikram
May be like this:
1) Num(Sum({<MonthYear = {'Jun-16'}>}Measure)/Sum({<MonthYear = {'Jan-14'}>}Measure) - 1, '##.0%')
2) Num(Sum({<MonthYear = {'Jun-16'}>}Measure)/Sum({<MonthYear = {'Aug-14'}>}Measure) - 1, '##.0%')
3) Num(Sum({<MonthYear = {'Jun-16'}>}Measure)/Sum({<MonthYear = {'Aug-15'}>}Measure) - 1, '##.0%')