Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pernillet
Contributor II
Contributor II

Hiding columns i table

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

5 Replies
swuehl
MVP
MVP

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

Not applicable

Hi,

You can try this in conditional.

=SubStringCount(Fieldname , 1)

Regards,

Janzen

pernillet
Contributor II
Contributor II
Author

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

pernillet
Contributor II
Contributor II
Author

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

Not applicable

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