Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
4 Replies
MayilVahanan

Hi

Try like this, in second expression

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

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

The totals for expression 2 are gone.

But now all null lines in the pivot table appears.

"Suppress When Value Is Null" = TRUE

canoebi99
Partner - Creator
Partner - Creator

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

Colin-Albert

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

Re: Dimensionality Function and its types