Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Prinky
Partner - Contributor II
Partner - Contributor II

How to suppress zero values in Qlik Sense variance waterfall chart

Hi All,

I need assistance with suppressing zero values in a Qlik Sense variance waterfall chart. While other charts in the properties panel typically offer an option to include or exclude zero values, this option seems unavailable for the Variance Waterfall chart.

Could you suggest a solution for suppressing zeroes, or recommend an alternative chart type?

Your response would be greatly appreciated. Thanks

Regards,

Prinky

Labels (1)
4 Replies
MatheusC
Specialist II
Specialist II

Hi, @Prinky 

Wouldn't that solve it here?

MatheusC_1-1714661078739.png

 


Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Prinky
Partner - Contributor II
Partner - Contributor II
Author

Hi @MatheusC ,

I appreciate your response. I attempted the method you suggested, but it doesn't seem to be functioning as anticipated.

The outcome is that all the dimension values are aggregated into a single bar labeled as 'Others'.

 

Prinky_2-1714701361782.png

Thanks.

Regards,

Prinky

Lisa_P
Employee
Employee

It should work, you should also deselect Others

Lisa_P_0-1714714878133.png

 

Prinky
Partner - Contributor II
Partner - Contributor II
Author

Hi @Lisa_P ,

Your response is greatly valued. It appears to be functioning, but the outcomes are restricted to either positive or negative values only.

 

Prinky_0-1714716377882.png

 

Prinky_1-1714716403942.png

Thanks.

Regards,

Prinky