topic Re: Null bar in waterfall bar chart in QlikView

Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 12:13:34 GMT

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

Re: Null bar in waterfall bar chart

sunny_talwar — Mon, 15 Jun 2015 12:21:00 GMT

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

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 12:23:27 GMT

Hi. It does not work unfortunately

Thanks

Hasnaa

Re: Null bar in waterfall bar chart

sunny_talwar — Mon, 15 Jun 2015 12:26:07 GMT

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

Re: Null bar in waterfall bar chart

petter — Mon, 15 Jun 2015 12:33:58 GMT

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

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 13:12:20 GMT

it still does not show anything

Re: Null bar in waterfall bar chart

sunny_talwar — Mon, 15 Jun 2015 13:13:14 GMT

Would you be able to share a sample?

Re: Null bar in waterfall bar chart

avinashelite — Mon, 15 Jun 2015 13:21:29 GMT

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

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 13:24:10 GMT

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

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 13:33:50 GMT

Check the image i attached. first bar missing

Thanks

Hasnaa

Re: Null bar in waterfall bar chart

avinashelite — Mon, 15 Jun 2015 13:34:21 GMT

OK , if you doesn't have dimension then please check the expression calculation once , I feel you don't have zero values, those are null values that's why they are not appearing, write a expression to check whether value is null , id so then set it to zero than only you will be able to see that value in the graph

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 13:37:10 GMT

ya its a null value, i tried using the following it still does not show anything for the missing bar

=if(NumSum($(f_Unit_Cost_In_Euro_StockInj))=0,

'Stock' & chr(10) & 'Injection',

dual('Stock' & chr(10) & 'Injection' & chr(10) & num($(f_Unit_Cost_In_Euro_StockInj),'# ##0,00'),$(f_Unit_Cost_In_Euro_StockInj)))

Re: Null bar in waterfall bar chart

avinashelite — Mon, 15 Jun 2015 13:44:39 GMT

can you share your app, so that it will be helpful to write the expression according to the data

Re: Null bar in waterfall bar chart

Anonymous — Mon, 15 Jun 2015 13:47:53 GMT

Hi. Sorry I cant share it as its a corporate stuffs. Thanks for your help

Regards

Hasnaa