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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! 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
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)