Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
sunny_talwar
Not applicable

Re: Suppress zeroes for only specific pivot columns?

Make those 0's into null

If(Expression <> 0, Expression)

1 Reply
sunny_talwar
Not applicable

Re: Suppress zeroes for only specific pivot columns?

Make those 0's into null

If(Expression <> 0, Expression)