Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

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