topic Re: Hiding zero figures in expression in QlikView

Hiding zero figures in expression

Sun, 28 Feb 2016 14:58:07 GMT

I want to hide all 0.00 in my table . Not suppress, I need the dimension to stay as its but hide the 0.00 in the expression @ Data

swuehl — Sun, 28 Feb 2016 15:22:49 GMT

Try a text color attribute expression (open the attributes by clicking on the small plus next to the expressions on expression tab):

=If( fabs( Sum(Value) )<=1E-12,White() )

replace sum(Value) with your expression

Sun, 28 Feb 2016 18:32:16 GMT

is there another way? the white isn't really solving the problem

swuehl — Sun, 28 Feb 2016 18:45:07 GMT

You can also use a condition in your expression, like

=If( fabs( Sum(Value) )> 1E-10, Sum(Value), '')

Again, replace Sum(Value) with your expression.

This should return an empty string instead of zero.

If this is not solving your problem, please describe in more detail what your problem is.