topic Re: Suppress Zero Values in Expression in QlikView

Suppress Zero Values in Expression

mahendragaur — Sat, 16 Nov 2024 04:23:40 GMT

I want to show only non-zero values in QlikView Pivot tables. I used suppress Zero Values but it is not working on QlikView Expression.

Any suggestion on this.

juliensaintmaxent3113 — Wed, 20 Feb 2019 10:23:34 GMT

hi,

try with set analysis: sum({$<MyMeasure={">0"}>}MyMeasure)

Bye

MindaugasBacius — Wed, 20 Feb 2019 14:20:19 GMT

Check the presentation tab in properties if the Supress Zero-Value is checked and in Dimensions tab there is also option Suppress When Value Is Null

mahendragaur — Thu, 21 Feb 2019 04:57:50 GMT

I tried both options. but it's not working

tresB — Thu, 21 Feb 2019 06:55:59 GMT

A quick tip to get faster and rightly directed solution to your query is to - provide a sample app