Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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