Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
neha_sri
Contributor III

Suppress null value from bar chart

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/

12 Replies
neha_sri
Contributor III

Re: Suppress null value from bar chart

bar chart.JPG

This is my sample chart

sinanozdemir
Valued Contributor III

Re: Suppress null value from bar chart

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

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

Re: Suppress null value from bar chart

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:

10-Jun-15 2-36-10 PM.jpg

buzzy996
Honored Contributor II

Re: Suppress null value from bar chart

try tis,

snullval.PNG

neha_sri
Contributor III

Re: Suppress null value from bar chart

I have trend line chart. This option is not present

neha_sri
Contributor III

Re: Suppress null value from bar chart


This also is not working for me

neha_sri
Contributor III

Re: Suppress null value from bar chart

Yes, but its not working

Partner
Partner

Re: Suppress null value from bar chart

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

Most likely the problem is in your expressions