topic Re: Removing Sub total from pivot tables in QlikView

Removing Sub total from pivot tables

Mon, 21 Nov 2016 13:55:41 GMT

Please can you assit. I am having trouble removing the Sub total from a simple Pivot table in QlikView.

The raw data consists of 7 columns, all are integers apart from the date.

The pivot table has the following fields:

Dimensions:

'' (blank)
TD

Expressions:

Number
CTM
Unmatched
New Acc
New Client

How can I remove the Sub Total (extra column on the end of the table)?

I have the following selected in the other tabs:

Thanks,

Re: Removing Sub total from pivot tables

adamdavi3s — Mon, 21 Nov 2016 13:58:55 GMT

Check if 'show partial sums' is selected when one of your dimensions is highlighted on the 'presentation' tab

I suspect that it must be, and simply unchecking the box should resolve the issue for you

Re: Removing Sub total from pivot tables

Mon, 21 Nov 2016 14:00:53 GMT

Thanks for the quick reply Adam. None of them are selected

Do you know what else it could be?

Re: Removing Sub total from pivot tables

sunny_talwar — Mon, 21 Nov 2016 14:02:44 GMT

Remove the check mark on 'Show Partial Sums' for TD and the other dimension to remove partial sums

Re: Removing Sub total from pivot tables

Mon, 21 Nov 2016 14:05:58 GMT

Thanks for the reply Sunny, but I dont have "Show Partial Sums" selected for any of the Expressions/Dimensions

Re: Removing Sub total from pivot tables

adamdavi3s — Mon, 21 Nov 2016 14:06:02 GMT

It isn't selected on either dimension on that tab? That is strange then!

However, have you tried saving, closing and re-opening the app? This might sound silly but there are some bugs in pivot tables in V12, although the bug I have is with them not showing up, rather than them showing up when not wanted.

Re: Removing Sub total from pivot tables

adamdavi3s — Mon, 21 Nov 2016 14:07:35 GMT

Hi Mary,

Actually one thing it might be worth trying and I could be wrong, is uncheck the 'always fully expanded' and then re-check to see if the dimensions have the 'show partial sums' checked. on either ='' or TD

Re: Removing Sub total from pivot tables

Mon, 21 Nov 2016 14:19:48 GMT

Thanks for your quick reply Adam

I think it is sorted now, I unticked the "Indent Mode" and its vanished.

Thank you for your suggestions and tips

Re: Removing Sub total from pivot tables

adamdavi3s — Mon, 21 Nov 2016 14:23:13 GMT

AH-ha yes that will do it as well! I am glad you have it sorted!

Do feel free to mark my answer as helpful and yours as correct if you like as it might help people in the future