Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendragaur
Creator
Creator

Suppress Zero Values in Expression

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.

Labels (1)
4 Replies
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

hi,

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

Bye

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

I tried both options. but it's not working
tresesco
MVP
MVP

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