Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Channa
Valued Contributor III

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

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

 

or while loading use preceding load and where measure >0

Channa
Partner
Partner

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

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

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

Unchecking this box did nothing to my graph.