Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to discard zero values in bar chart?

Hi to all,

As you see in screenshot below, I could not discard zero values in bar chart. Is there anybody who knows how to achieve this?

Thank a lot in advance!

screenshot deneme.png

23 Replies
Highlighted
Master III
Master III

in dimension

               disable show zero values

in add-ons

               disable show zero values

Highlighted
Not applicable

Hi Arul,

I have tried your suggestion, but unfortunately it does not work 

Highlighted
Champion III
Champion III

here

zer.PNG

Highlighted
Not applicable

As you see, it does not work

Screenshot deneme 2png.png

Highlighted
Master III
Master III

in dimension try this

if(Len(Trim(field)) > 0,field)

Highlighted
Champion III
Champion III

try

=if(sum( urfieldname)>0,sum( uefieldname),null())

Highlighted
Master III
Master III

can you post the app

Highlighted
Not applicable

Hi Arul,

Unfortunately I cannot post it, but i took the screenshots of my dimension and expression region. Thanks a lot for your consideration.

My dimension is:

dimension.png

and one of my expression values is like this one: (by the way, i have 8 expression values in total.)

expression.png

Highlighted
Master III
Master III

can you remove the null() from dimension and check it what you getting