Filter Table to Show/Hide Rows Based on Data

[bettyplummer]

I'm new to Qlik Sense, so there's probably an easy way to do this that I don't know about.

I have a table with multiple columns and one measure - Qty.  I want to filter that table to only show rows where Qty < Min (another column).  I can't use an If statement to display 0 and then uncheck 'Include zero values', because some of the values I need to keep will be zeros.  Not having any luck with Set Analysis (still learning the syntax).

Any ideas?

[pmoreno17 · Accepted solution]

Hi Betty!

Try this:

sum({<Qty={"<$(=Min(Column))"}>}Qty)

Regards!

[bettyplummer]

That did work, thanks!  Never returned to accept the solution - better late than never 😁