Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Suppress Zero values option in the Straight table

Hi Folks, I am trying to remove the zero values from my straight table. Then I selected "Suppress Zero Values" on the presentation tab for straight table. But still the it returns the zero values on the Table.

Can I still check any other conditions or It is a bug on the software ?

Appreciated!......

5 Replies
Clever_Anjos
Employee
Employee

All expressions should return "0" in order to a row to be hidden, check the other expressions result

rustyfishbones
Master II
Master II

It should work

Are you sure the values are 0?

Maybe 0.00% could be 0.0000125% and therefore not quite a zer value????

Not applicable
Author

I believe, If we rounded the value to 2 precision values and the returned value should be zero

Clever_Anjos
Employee
Employee

Use round

round(yourexpression,0.01)

sujeetsingh
Master III
Master III

Seems you should set value as null() when it is zero and supress null