Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kranthi_bhattu
New Contributor

Growth KPI's calculation on line chart for continuous years

Hello Experts,

Can some one please help in how to calculate Growth KPIs ( Year-1, Period -1, CAGR) in qlik sense expression.

Following is my data schema , screen shot of visualization requirement  .

Product YearSales
A2010       4,83,39,016
A2011       1,48,29,154
A2012       1,42,73,602
A2013       2,38,06,291
A2014       8,34,01,655
A2015       9,26,99,648
A2016       8,13,40,752
A2017       6,39,78,701

Capture.PNG

Thanks,

Kranthi

3 Replies
devarasu07
Honored Contributor II

Re: Growth KPI's calculation on line chart for continuous years

Hi,

you can try like this

Sales Growth Expression (year sorting will be ascending order)

Sum(Sales)/Above(Sum(Sales)) - 1 // line graph chart expression

Sum(Sales)/Before(Sum(Sales)) - 1  //for pivot table chart expression


Capture.JPG

kranthi_bhattu
New Contributor

Re: Growth KPI's calculation on line chart for continuous years

Hello Devarasu,

Thanks for the quick reply, the approach works for the single dimension data.

However, when we include more attributes like region, country and area,... to the data and filter options the formulea behaves randomely.

Regards,

Kranthi

Re: Growth KPI's calculation on line chart for continuous years

The other option is to use The As-Of Table

Updated devarasu07‌'s attached sample with the asoftable approach

Community Browser