Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Highlighted
Employee
Employee

Re: Problem with Suppress Zero values option in the Straight table

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

Highlighted
rustyfishbones
Honored Contributor II

Re: Problem with Suppress Zero values option in the Straight table

It should work

Are you sure the values are 0?

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

Highlighted
Not applicable

Re: Problem with Suppress Zero values option in the Straight table

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

Highlighted
Employee
Employee

Re: Problem with Suppress Zero values option in the Straight table

Use round

round(yourexpression,0.01)

Highlighted
sujeetsingh
Honored Contributor III

Re: Problem with Suppress Zero values option in the Straight table

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