topic Re: How to hide the Grand Total row in Pivot Table in QlikView

How to hide the Grand Total row in Pivot Table

Thu, 21 Jan 2010 22:33:06 GMT

Is it possible to hide the Grand Total row in a pivot table without hiding the subtotals?

See screen shot

How to hide the Grand Total row in Pivot Table

Thu, 21 Jan 2010 22:38:09 GMT

Yes. Totals in Pivot Tables are handled with Partial Sums on the Presentation tab. The grand total is the highest (first) dimension. Go to the Presentation tab, highlight the top dimension and remove the check on Show Partial Sums.

The other subtotals are hidden/shown based on the Show Partial Sum checkbox when other dimensions are selected on that tab.

How to hide the Grand Total row in Pivot Table

Thu, 21 Jan 2010 22:46:52 GMT

Yes, I understand this but I would like the subtotals to still be displayed on the pivot table.

How to hide the Grand Total row in Pivot Table

Thu, 21 Jan 2010 23:02:15 GMT

You can uncheck "Show Partial Sums" only for the first "Dimension" in Presentation tab.

How to hide the Grand Total row in Pivot Table

Thu, 21 Jan 2010 23:33:30 GMT

Exactly. Each dimension has its own Show Partial Sums checkbox. The first dimension is the grand total. Your subtotals will have a separate checkbox. Go to that tab and highlight each dimension and you will see.

How to hide the Grand Total row in Pivot Table

Fri, 22 Jan 2010 14:10:59 GMT

That works. Thank you very much everybody.

Re: How to hide the Grand Total row in Pivot Table

Mon, 03 Dec 2012 15:46:18 GMT

Hello Community Members,

The checkbox of the Paritial Sums is not enabled in my qlikview. I am using QlikView11 version

Thanks in advance

ramesh

Re: How to hide the Grand Total row in Pivot Table

Wed, 06 Mar 2013 14:07:05 GMT

I just solved this problem. Since this is the top-level result in Google, I wanted to help out others who might land here.

To make the Grand Total row disappear, I added an "if" statement to every expression. It referenced the top-level dimension, returning a NULL() if the distinct count of that dimension was greater than 1. This made every column NULL on the Grand Total row. With "Suppress Zero-Values" enabled and "Suppress Missing" grayed out in the "Presentation" tab of the chart properties, the Grand Total row disappeared.

I hope this helps!

Message was edited by: bhimes100. Spelling: changed "Supper" to "Suppress.

Re: How to hide the Grand Total row in Pivot Table

berndjaegle — Fri, 20 Nov 2015 09:37:49 GMT

Hi wvogt,

I got it fixed with dimensionality().

Might not be a very dynamic solution, but it fixed my table.

The Total has two dimensons. These are the first two columns of my table. Please see png.

if (Dimensionality()=2, '',
sum(Material.GivAmount) * sum(Order.Amount)
)

Cheers Bernd

Re: How to hide the Grand Total row in Pivot Table

Anonymous — Wed, 24 Aug 2016 17:29:50 GMT

Please, check the correct answer.

thank you