topic Re: Hiding columns i table in QlikView

Hiding columns i table

pernillet — Mon, 29 Oct 2012 10:04:53 GMT

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

Re: Hiding columns i table

swuehl — Mon, 29 Oct 2012 10:15:53 GMT

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

Re: Hiding columns i table

Mon, 29 Oct 2012 10:19:38 GMT

Hi,

You can try this in conditional.

=SubStringCount(Fieldname , 1)

Regards,

Janzen

Re: Hiding columns i table

pernillet — Mon, 29 Oct 2012 10:59:38 GMT

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

Re: Hiding columns i table

pernillet — Mon, 29 Oct 2012 11:02:23 GMT

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

Re: Hiding columns i table

Mon, 29 Oct 2012 12:17:46 GMT

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