How to eliminate null or blank or 0 values in Barchart in Qlik Sense

[scotly-victor]

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?

[sunny_talwar]

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?

[rubenmarin]

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)

[reddy-s]

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.

[Chanty4u]

chk dis

NULL handling in QlikView

[scotly-victor]

Thank you  sangram

it works fine

[reddy-s]

Always Welcome!

[ptwistp1]

This was the solution for me, thank you