topic Re: Pivot Totals in QlikView

Pivot Totals

Sun, 09 Mar 2014 07:49:34 GMT

A simple question...

I have a Pivot Table with Year as primary Pivot and then Budget Topics. How do I get a full sum of all budget topics for the year ?

Meir

veidlburkhard — Sun, 09 Mar 2014 14:17:02 GMT

Hi Meir,

add a last expression to your expression list like column(1) + column(2) +...+ column(n) and name it 'Total Budget'.

Then for every year you will get the sum of all budget topics as a last column at the end of your pivot table.

Hope this helps

Burkhard

maxgro — Sun, 09 Mar 2014 14:24:23 GMT

try this:

in tab Presentation of Pivot Table chart there is a check box for Partial Sum

Mon, 10 Mar 2014 09:08:50 GMT

Thanks for the suggestions. The best solution was to import using the pivot wizard.

Regards

Meir

Mon, 10 Mar 2014 09:10:20 GMT

Thanks I was thinking that would be the solution but there are about 25 columns so its a bit tedious.

I decided to import the table using the pivot that way I have the drill down and the partial sum solution.

Regards

Meir