QlikView Using an expression result as a selection or list box

Question

I have a simple straight table that has a dimension and an expression.

=If(Only({1}YOURFIELD) - Above(Only({1}YOURFIELD)) = 1, 'Match', 'Check')

The expression either outputs Match or Check.

However I cannot select the expression results to only show Match or Check with the results.

Answer 1

This can be done by creating a list box using this expression:

Aggr(If(Only({1}YOURFIELD) - Above(Only({1}YOURFIELD)) = 1, 'Match', 'Check'), DimensionsFromYourTableHere)

Small Edit to show EldadT how this works: