topic Re: Bar Chart with (empty) bars in QlikView

Bar Chart with (empty) bars

Wed, 10 Dec 2014 08:57:41 GMT

Hi guys,

I have created a bar chart with 2 expressions and 1 dimension. Furthermore I have also selected "Suppress when value is null" and "supress zero values". However my chart shows a blank bar (so a white space for one empty bar) in case one of my expressions has no values.

Do you know how to suppress these empty bar ?

Best

Harry

Re: Bar Chart with (empty) bars

ThornOfCrowns — Wed, 10 Dec 2014 09:02:35 GMT

What's on the axis in that picture?

Re: Bar Chart with (empty) bars

Anonymous — Wed, 10 Dec 2014 09:03:17 GMT

Hi,

In Script:

If (Len(Trim(FieldName) > 0),1,0) as FieldName1

In Bar Chart :

=Count({<FieldName1 = {'1'}>} FieldName)

Regards

Neetha

Re: Bar Chart with (empty) bars

vinay_hg — Wed, 10 Dec 2014 09:06:32 GMT

check "supress when value is null" option in dimesion and uncheck "show all values" if checked. then empty bar will not come. this will happen when there is no value in dimension against expression items, all the values consolidates and comes in separate bar with '-' sign.

see for the option below in dimesion tab in chart properties

Re: Bar Chart with (empty) bars

Wed, 10 Dec 2014 09:30:37 GMT

Thanks! With Neethas solution I have now the empty bar displayed as 0% in case there are no values. However I want to hide this bar in case there are 0%.

Does anyone know how to do this?

Many thanks,

Harry

Re: Bar Chart with (empty) bars

Anonymous — Wed, 10 Dec 2014 09:35:00 GMT

Hi,

it might be 0.20%, change formatting to display decimal as well.

Regards

neetha

Re: Bar Chart with (empty) bars

Wed, 10 Dec 2014 09:47:37 GMT

Thanks Neetha! I have checked and the result is 0.0000.

Best

Harry

Re: Bar Chart with (empty) bars

Anonymous — Wed, 10 Dec 2014 09:51:30 GMT

Try in script:

If (Len(Trim(FieldName) => 1),1,0) as FieldName1