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

[bertrand_herard]

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]

I used a calculated dimension:

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

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

[Chanty4u]

hi,

PFA

Is this?