Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

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
Honored Contributor III

Re: Removing zero totals when a selection is made

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

big_dreams
Contributor III

Re: Removing zero totals when a selection is made

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

Use round or ceil () to make it 0.

Regards,

hammermill21
Contributor II

Re: Removing zero totals when a selection is made

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
Contributor III

Re: Removing zero totals when a selection is made

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

omarbensalem
Esteemed Contributor

Re: Removing zero totals when a selection is made

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

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