Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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)