topic Re: Total in pivot table in QlikView

Total in pivot table

Wed, 07 Sep 2016 13:50:50 GMT

Hello,

I need to show totals in a pivot table, where “carrier name” and “year” are the dimensions and the sum of #trasported passangers is the expression. The year dimension is shown horizontally (on top) like in the image below.

I tried to check the flag “Show partial sum” in the properties but it doesn’t work.

How can I do?

Thanks

Re: Total in pivot table

sunny_talwar — Wed, 07 Sep 2016 19:34:52 GMT

Did you try scrolling all the way to the bottom to see if the Totals are available there?

If you want them to be visible at all times, may be put them on the top from the presentation tab

Re: Total in pivot table

Thu, 08 Sep 2016 10:58:53 GMT

Thanks.

I tried to check “Show partial sums” again and now scrolling I can see the totals.

I was sure that they weren’t visible also scrolling down to the bottom. I don’t know.

Is there a way to show the totals at the bottom also without scrolling?

Re: Total in pivot table

sunny_talwar — Thu, 08 Sep 2016 15:51:56 GMT

I don't think that is possible, but there might be a work around or a macro.