topic Re: Bar Chart Columns Visibility in QlikView

Bar Chart Columns Visibility

Anonymous — Wed, 07 Mar 2018 18:45:30 GMT

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

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.

Re: Bar Chart Columns Visibility

sunny_talwar — Wed, 07 Mar 2018 18:50:25 GMT

May be this

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

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

Re: Bar Chart Columns Visibility

Anonymous — Wed, 07 Mar 2018 18:58:37 GMT

Awesome!!! worked perfect.

Then in presentation I unchecked "suppress Zero-values" and checked Zero on bars so I can have this: