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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar Chart Columns Visibility

Hello guys,

Currently I'm working in a new dashboard and I'm kind of blocked with a Bar Char property:

I have this expression in this chart:

(Sum({<Año = {$(vMaxYear)}>} Hl) / Sum({<Año = {$(=$(vMaxYear)-1)}>} Hl))-1

QV Question.PNG

And I don't want to show the bars that are showing -100% due to the lack of data; for april 2018 I don't have any so the division is zero so I want to show it as a zero bar (or if there is another solution).

How can I do this?

Thank you very very much.

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(Sum({<Año = {$(vMaxYear)}>} Hl) <> 0,

(Sum({<Año = {$(vMaxYear)}>} Hl) / Sum({<Año = {$(=$(vMaxYear)-1)}>} Hl))-1)

View solution in original post

2 Replies
sunny_talwar

May be this

If(Sum({<Año = {$(vMaxYear)}>} Hl) <> 0,

(Sum({<Año = {$(vMaxYear)}>} Hl) / Sum({<Año = {$(=$(vMaxYear)-1)}>} Hl))-1)

Anonymous
Not applicable
Author

Awesome!!! worked perfect.

QV Answer.PNGThen in presentation I unchecked "suppress Zero-values" and checked Zero on bars so I can have this: