Hiding columns i table

[pernillet]

I'm trying to hide my column, when my expression is returning null.

Do anyone know what to write in tabele->properties->presentation-> conditional, when I don't want to show the column if it has a null value?

Best

Pernille

[swuehl]

You want to hide the column when the expression total returns zero?

Maybe use something like

sum(Value) <> 0

as conditional expression, replace sum(Value) with your expression.

In QV11, you can also use a conditional expression, so your column won't even be calculated.

edit: conditional expression = TRUE will show the column

[#3]

Hi,

You can try this in conditional.

=SubStringCount(Fieldname , 1)

Regards,

Janzen

[pernillet]

What is teh Fieldname, when I have an expression, which gives a number or null?

[pernillet]

what to write as value, when I need the column value..column(1) doesn't work.

[#6]

if you are using QV11 , then we have some thing called "conditional" next to enable in Expression Tab, there you can write some thing like if(isnull(filedName),0,1)

hope it helps..

Thanks & Regards,

Venkat T