Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

2 Replies
ian_wilson
Support
Support

I think this is what you are after:

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

x = previous quarter

y = next quarter

JonnyPoole
Employee
Employee

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)