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: 
Not applicable

Suppressing a row based on the output of a single expression when there are multiple expressions

Hi all. So I have a table chart with a number of expressions. Some of these expressions are binary flags, 1 or 0, depending on a condition. I was using these expressions to remove rows where the expressions equal 0 using the Supress Zero Values option. Some expressions reference each other though, so I check whether or not another expression came back 1 before calculating.

Is there a way to force the row to disappear based on the value of just a single expression, even if the other expressions have non-zero values?

My problem is if some of the conditions come back 1, but a later one comes back 0, I need the row to disappear. Since they reference each other in a series of sequential checks, I can't go back and use a later expression as a condition for an earlier one.

I hope this isn't too confusing. Thanks for the help!

0 Replies