Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
murgoimarius
Contributor
Contributor

Waterfall chart hide 0 values

Hi, I have a waterfall chart in qlik. If no filters are selected, values are displayed in every bar, but once I start applying filters, some bars will have 0 values.

What I want, and can't do, is if a bar has 0 values to dissapear. 

In data handling I don't have the option to supress 0 values.

Since every bar is a differet measure, is it even possible to hide a bar if the value is 0 or null?

 

Thanks,

Labels (5)
3 Replies
TcnCunha_M
Creator III
Creator III

Do go the dimension and remove show zero values

As you think, so shall you become.
murgoimarius
Contributor
Contributor
Author

Hello, I don't have dimensions, every bar is a measure...

TcnCunha_M
Creator III
Creator III

Have you try to use if conditional if the value > 0 , expression, else null())?

As you think, so shall you become.