topic Re: Suppress null value from bar chart in QlikView

Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:30:51 GMT

I have a bar chart which is showing '-' as dimension. I want to remove /hide it.

I have tried suppress null value but it is not working for me.

How can I remove it/

Re: Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:34:15 GMT

This is my sample chart

Re: Suppress null value from bar chart

sinanozdemir — Wed, 10 Jun 2015 13:34:55 GMT

Hi Neha,

In your expression, you can write something similar to the below:

Count/Sum({<Dimension = {"*"}>} Value)

Dimension is the dimension causing null values.

Hope this helps.

Re: Suppress null value from bar chart

sunny_talwar — Wed, 10 Jun 2015 13:35:12 GMT

Have you tried 'Suppress When Value is Null' on the Dimensions tab of the chart properties?

Re: Suppress null value from bar chart

robert_mika — Wed, 10 Jun 2015 13:37:10 GMT

Do you want to hide members of the dimension or remove the whole dimension?

If the latest you can just move the dimension from Used Dimension window into Available fields

if the first try here:

Re: Suppress null value from bar chart

buzzy996 — Wed, 10 Jun 2015 13:40:58 GMT

try tis,

Re: Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:41:22 GMT

I have trend line chart. This option is not present

Re: Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:41:49 GMT

This also is not working for me

Re: Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:42:09 GMT

Yes, but its not working

Re: Suppress null value from bar chart

giakoum — Wed, 10 Jun 2015 13:43:40 GMT

a sample app would help as all straight forward suggestions do not work for you.

Most likely the problem is in your expressions

Re: Suppress null value from bar chart

neha_sri — Wed, 10 Jun 2015 13:43:42 GMT

This also is not working for me

Re: Suppress null value from bar chart

buzzy996 — Wed, 10 Jun 2015 13:44:14 GMT

if,tht's the case those are not not values.

pls share ur app if possible?

Re: Suppress null value from bar chart

sinanozdemir — Wed, 10 Jun 2015 13:45:56 GMT

Maybe they are not NULL values, just blank values.

In this case,

Count/Sum({<Dimension = {"<>''"}>} Value)

Hope this works