topic Re: period over period growth% in QlikView

period over period growth%

Fri, 31 Oct 2014 22:52:19 GMT

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

swuehl — Fri, 31 Oct 2014 23:16:52 GMT

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

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

Sat, 01 Nov 2014 00:25:29 GMT

Hi Swuehl,

It works with Above().

Regards,

Daniel