topic Re: QlikView question - how to hide null values and keep zero values in a pivot table in QlikView

QlikView question - how to hide null values and keep zero values in a pivot table

bertrand_herard — Thu, 24 Mar 2016 15:42:31 GMT

Hello,

I've a problem which seems very simple :

I want to hide rows in a pivot table where expressions values are all equal to null()

BUT I want to keep lines where at least one expression value is equal to zéro.

Do you know how to do that ? (Or how to workaround it) ?

I've attached a quick sandbox example. As it may be more complex than it seems :), please try your solution

in this file before answering

Best regards

sunny_talwar — Thu, 24 Mar 2016 15:55:56 GMT

I used a calculated dimension:

=Aggr(If(not IsNull(Value), Code), Code)

With 'Suppress When Value Is Null' checked on the dimension tab

Chanty4u — Thu, 24 Mar 2016 16:00:44 GMT

hi,

PFA

Is this?