Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
juan_escobar
Creator II
Creator II

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)

View solution in original post

juan_escobar
Creator II
Creator II
Author

Awesome!!! worked perfect.

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