Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using a formula for KPI in Qliksense

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.

 

AssetJan-14Aug-14Jan-15Aug-15Jan-16Jun-16
Area 1020001950192019101900

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

1 Reply
sunny_talwar

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%')