Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Jsaintmaxent
Luminary Alumni
Luminary Alumni

hi,

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

Bye

MindaugasBacius
Partner
Partner

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