1 Reply Latest reply: Aug 11, 2016 10:42 AM by Sunny Talwar

# 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.

 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

• ###### Re: Using a formula for KPI in Qliksense

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