Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vanhappen
New Contributor

I don't want to show all totals in a pivot table

I don't want to show all totals in a pivot table.

There are 3 expressions (all of them are SUM calculations).

I want to show the totals for 2 dimensions.

See example below

Expression 1 (SUM x)Expression 2 (SUM y)Expression 3 (SUM z)
102030
405060
Total: 50EMPTY!Total: 90
Tags (3)
4 Replies

Re: I don't want to show all totals in a pivot table

Hi

Try like this, in second expression

=if(RowNo() = 0 or isnull(rowno()) , '' , Sum(y))

hope it helps

vanhappen
New Contributor

Re: I don't want to show all totals in a pivot table

The totals for expression 2 are gone.

But now all null lines in the pivot table appears.

"Suppress When Value Is Null" = TRUE

canoebi99
New Contributor III

Re: I don't want to show all totals in a pivot table

Hi I needed to do the same and I think changing the code provided to:

=if(RowNo() = 0 or isnull(rowno()) , null() , Sum(y))


will resolve the issue with null lines showing.


Thanks

Highlighted

Re: I don't want to show all totals in a pivot table

You can use dimensionality function to control the visibility of the totals

Re: Dimensionality Function and its types

Community Browser