Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Suppress zeroes for only specific pivot columns?

Hey there, so I need to keep suppress zeros off in the presentation of a qlikview pivot table but only for one column 'actuals', not the other ones, is there a way to selectively do this? So far it seems like an on and off toggle and all or nothing, but maybe there might be a more clever fashion?

Capture.JPG

1 Solution

Accepted Solutions

Re: Suppress zeroes for only specific pivot columns?

Make those 0's into null

If(Expression <> 0, Expression)

View solution in original post

1 Reply

Re: Suppress zeroes for only specific pivot columns?

Make those 0's into null

If(Expression <> 0, Expression)

View solution in original post