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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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