topic Hide total in pivot in QlikView

Hide total in pivot

Wed, 12 Aug 2009 16:23:28 GMT

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:

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.

Hide total in pivot

Wed, 12 Aug 2009 17:15:39 GMT

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

Kind Regards

Footsie

AW:Re: Hide total in pivot

Wed, 12 Aug 2009 17:33:15 GMT

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.

Sometimes you miss the wood for the trees.

Thanks!