Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Hide zero values

Hi Experts,

I'm using combo chart with multiple expressions, few expressions has zero values.

Any workaround to exclude Zero values ?

paulwalker_0-1742908438669.png

 

Labels (2)
6 Replies
JR4
Contributor II
Contributor II

You should be able to hide zero values by going to add-ons, data handling, and unchecking the box to include zero values

JR4_0-1742909343839.png

 

Or
MVP
MVP

What you circled aren't zero values... there's a 3 in there. And presumably the other groups also have at least one value for a dimension member (month), which is why they're showing up?

paulwalker
Creator III
Creator III
Author

I did check this but nothing change

paulwalker
Creator III
Creator III
Author

Product wise I have written measure, but few measures doesn't have values because showing the Zero.

But User doesn't wants see zero values.

Or
MVP
MVP

I'm sorry, it's not helpful to me if you just say the exact same thing you did before without referring to what I wrote. These are presumably not zero value measures.

Chanty4u
MVP
MVP

Try this

If(Sum([YourMeasure]) > 0, Sum([YourMeasure]))

 

 

Or 

Sum({<YourField={"<>0"}>} YourMeasure)