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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress rows where expression is null?

Hi all. So I have a table chart with a number of dimensions and expressions. I have a particular expression where, if it doesn't have a value, I don't want the table to display that row. I know you can do this with a dimension, but can it be done with an expression? Thanks!

Eric

1 Reply
swuehl
MVP
MVP

Yes, there are some options on the presentation tab for that, especially "supress zero values".

But I believe this works only if all your expressions return zero or NULL on that row, if you want to hide that row in condition of only one expression, I think you could use something like

=if (column(MYEXPRESSIONCOLUMN) = 0,   //or if(isNULL(column(MYEXPRESSION)), ??

0,

YOUREXPRESSION

)

Hope this helps,

Stefan