Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
scotly-victor
Creator II
Creator II

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?

7 Replies
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
Master II
Master II

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
MVP
MVP

scotly-victor
Creator II
Creator II
Author

Thank you  sangram

it works fine

reddy-s
Master II
Master II

Always Welcome!

ptwistp1
Contributor III
Contributor III

This was the solution for me, thank you