
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to eliminate null or blank or 0 values in Barchart in Qlik Sense
Hi Everyone,
I wanted to remove null or blank or 0 values in Barchart in Qlik Sense.
I want only positive or negative value.
Can anyone help me?
- Tags:
- remove null

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
If(Expression <> 0, Expression)
and then check 'Suppress When Null'
If it doesn't work, would you be able to provide a sample?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi scotly, in the right margin there are the properties of the chart, in 'Complements' you can uncheck the option to show zero values.
In the dimensions you can check the option to supress null values (null in dimension). You can use Alt() to force the expression to return a number:
Alt(YourExpression, 0)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Scotly,
Under the dimension properties you can un-check the "show Nulls" check box, this remove the nulls.
And under the Add ons properties panel, you can check the "suppress zero values", this will remove all the zero values.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
chk dis

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you sangram
it works fine


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Always Welcome!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This was the solution for me, thank you
