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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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