Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Former Employee
Former 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)