topic Waterfall Chart - Show bar even if 0 value in QlikView

Waterfall Chart - Show bar even if 0 value

joshabbott — Wed, 03 Aug 2011 12:55:12 GMT

I am working on a waterfall chart, and one issue I've come upon is 0 values. I don't want the bar to be supressed if the value is 0, instead, I want it to show 0 and to show a line where the value would be (small bar). I found a way to do this by using an if statement in set analysis, so it would be something like:

if(complex set analysis = 0, .1, complex set analysis) - Since I'm displaying only whole numbers, this shows me a small bar and a value of 0.

Right now, I am trying to make the application more effecient and the if statement is a high cost function that I would like to take out if possible. I'm assuming with the if statement, my complex set analysis is having to run twice in most instances. Does anyone have a suggestion for a way to make this more effecient? Thank you!

Waterfall Chart - Show bar even if 0 value

Wed, 03 Aug 2011 13:32:04 GMT

Hi, I think you can use a rangemax function or rangemin depending on your particular case, like this:

rangemax(complex set analysis, .1)

Regards

Waterfall Chart - Show bar even if 0 value

joshabbott — Wed, 03 Aug 2011 17:58:59 GMT

This may be the way I can go, unfortunately, on a bar by bar basis, the number could be positive or negative.

Re: Waterfall Chart - Show bar even if 0 value

Wed, 03 Aug 2011 18:25:05 GMT

Hi again, please find attach a waterfall example using a different approach. The main point out of this is using the column value calculated in an invisible column and then use the if statement on the amount and not in the actual expression.

Hope this helps

Regards

Re: Waterfall Chart - Show bar even if 0 value

joshabbott — Wed, 03 Aug 2011 18:38:20 GMT

That is genius, thank you so much. That works perfect for what I'm trying to do. Thanks!