topic Re: Pivot total sum and calculations in QlikView

Pivot total sum and calculations

Thu, 28 Jan 2016 16:35:55 GMT

Hi,

I am new to QlikView.

I have a pivot table where you can select products and time. I do sum/totals pr. month as the grey below.

I would like to add 1 SUM across the selected time, in yellow (e.g. for the 3 months selected below).

Later I would like to add more complex calculations e.g. growth pr. month (between the months) by calculating difference between current and previous months.

What to do?

Re: Pivot total sum and calculations

swuehl — Thu, 28 Jan 2016 19:07:29 GMT

You can add partial sums also to your pivoted Month dimension, go to presentation tab, select the appropriate dimension and enable 'Show partial sums' for each dimension, where needed.

To calculate growth, look into chart inter record functions, namely Above() / Below() resp. Before() / After() for pivoted dimensions.

Something like

=Sum(Value) / Before(Sum(Value)) -1

for Growth calculated respecting your pivoted Month.

Re: Pivot total sum and calculations

Fri, 29 Jan 2016 09:04:08 GMT

Absolutely fantastic! Thanks for the swift reply