Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashrivastav2
Partner - Contributor II
Partner - Contributor II

How to suppress zero values of a measure (NOT of a field)?

I have created a chart and I don't want any of the measure's zero values to be plotted. How do I do this?

Labels (2)
3 Replies
Channa
Specialist III
Specialist III

=Sum({<DImension= {"=Sum(Measure)) >0"}>}Measure)

 

or while loading use preceding load and where measure >0

Channa
Vegar
MVP
MVP

Many, maybe all, chart objects have an include zero values checkbox in the object properties under the header "add-ons" - "Data handling".

If you uncheck that property box you will exclude all zero values from your chart.

ashrivastav2
Partner - Contributor II
Partner - Contributor II
Author

Unchecking this box did nothing to my graph.