Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

period over period growth%

Hello,

I'm trying to build a period over period growth % chart(not pivot table) but so far I didn't find a way to do that.

I was able get this in a pivot table using the before() function, but I want to do it also in a bar chart.

This is the formula I used for the growth % in the pivot table:

SUM(Amount)/Before(SUM(Amount)) - 1

Is there a way to do this in a chart? My time dimension is based on months.

Thanks in advance,

Daniel

1 Solution

Accepted Solutions
swuehl
MVP
MVP

In a straight table chart (or bar chart), try with the above() inter chart record function:

SUM(Amount)/ ABOVE(SUM(Amount)) - 1

View solution in original post

2 Replies
swuehl
MVP
MVP

In a straight table chart (or bar chart), try with the above() inter chart record function:

SUM(Amount)/ ABOVE(SUM(Amount)) - 1

Not applicable
Author

Hi Swuehl,

It works with Above().

Regards,

Daniel