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: 
Anonymous
Not applicable

Null bar in waterfall bar chart

Hi

I have an issue in the graphics of a waterfall chart. For some bars, I have null value or zero. Thus there is an empty space for the missing bar. I would like to still display at least the labelling for the bar. Is this possible when using dual?  Please find below image

Thanks

Hasnaa

Waterfall null.png

13 Replies
sunny_talwar

Try unchecking Suppress Zero-Values option on the presentation tab and see if that helps

Capture.PNG

Anonymous
Not applicable
Author

Hi. It does not work unfortunately

Thanks

Hasnaa

sunny_talwar

So the problem is that the 0 value bars are not showing anything??

petter
Partner - Champion III
Partner - Champion III

You should tick/check the "Zero on Bars" that are immediately below the "Suppress Zero-Values" ...

Anonymous
Not applicable
Author

it still does not show anything

sunny_talwar

Would you be able to share a sample?

avinashelite

Hi Hasnaa,

Why your using dual here ?? any specific reason ?

I think with out using dual, by checking show zero values and in the Dimension by checking > show all values , should solve the problem

Anonymous
Not applicable
Author

Hi Im using dual to be able to display a text on each bar. I dont have anything in dimension.  I have an expression for each bar

Thanks

Hasnaa

Anonymous
Not applicable
Author

Hi

Check the image i attached. first bar missing

Thanks

Hasnaa