Discussion board where members can get started with Qlik Sense.
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 .
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
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.
The other option is to use The As-Of Table
Updated devarasu07's attached sample with the asoftable approach