Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Re: Calculating Growth in a pivot table

Hello, I am a newbie and this is my first post. I need to show the growth percentage quarter over quarter and am stuck. Do you have any suggestions of how I would do this? I tried Column-Column/Column ect.. not working. I have attached a screen print.

Tags (2)
2 Replies
Employee
Employee

Re: Calculating Growth in a pivot table

I think this is what you are after:

formula =((y-x)/x)*100

x = previous quarter

y = next quarter

Employee
Employee

Re: Calculating Growth in a pivot table

The above() function will grab the value from the preceding row. It may help you

ex:

( Sum(Sales) - above(Sum(Sales),1) ) /  above(Sum(Sales),1)