Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Former Employee
Former Employee

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)