Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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