Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide total in pivot

Hi,

i´ve got a pivot with the sum of sales, sum of amount and with both of them i invoice the single price. It doesn´t make sense to show the single-price in total, so i want to hide it. I´ve added an if-clause for it:

=IF(ISNULL(RowNo()) OR RowNo()=0,'',Sales/Amount)

It works fine, but now all customers, also these ones without any sales where shown. Without my if-clause they´re hidden:

error loading image

Has anyone an idea how to handle it? Perhaps there´s a different solution without if-clauses for hiding the total in pivot.

I´ve attache my app for testing.

Ragards.

1 Solution

Accepted Solutions
Not applicable

On the Dimensions tab check "Supress when value is null" on the Customer Dimension.

Kind Regards

Footsie

View solution in original post

2 Replies
Not applicable

On the Dimensions tab check "Supress when value is null" on the Customer Dimension.

Kind Regards

Footsie

View solution in original post

Not applicable

Omg, at least it was so easy!

I´ve tried everything and the function "Supress when value is null", too, but not for all dimensions. Angry

Sometimes you miss the wood for the trees. Big Smile

Thanks!