Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashrivastav2
Partner - Contributor
Partner - Contributor

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
Partner - Contributor
Author

Unchecking this box did nothing to my graph.