Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Removing zero totals when a selection is made

Hello,

I have a bar chart that I have selected to remove the zero value under data handling which is perfect, but when I make a selection on the map and the bar chart adjust to that selection is shows zero values. Can that be removed?

I am attaching two pics once showing how it is set to remove the zero values, then what it looks like when I make a selection on the map.

Thank you!

5 Replies
shraddha_g
Partner - Master III
Partner - Master III

It might be having values in decimal after 0. That might be reason that it is appearing even after removing zero values

big_dreams
Creator III
Creator III

I agree with Shraddha, It is because of decimal value.

Use round or ceil () to make it 0.

Regards,

hammermill21
Creator III
Creator III
Author

HI,

Thank you but no that's not working. I'm thinking I should add something to my expression to overlook the zeros.

I currently have this: =Count({<[New  /  Revised]= {'NEW'}>} EP#)/16

big_dreams
Creator III
Creator III

what do you want to do with such lowest value??

OmarBenSalem

If they're there, It means that are not zeros !

Try to format ur expression with 2 numbers after the , and u'll see !