Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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 (3)
3 Replies
Highlighted
Specialist III
Specialist III

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

 

or while loading use preceding load and where measure >0

Channa
Highlighted
Partner
Partner

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Unchecking this box did nothing to my graph.