Using an expression result as a selection

[matthewp]

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

The expression either outputs yes or no.

However i cannot select the expression results to only show yes's or only show no's

can this be done?

[sunny_talwar]

May be like this, to show just yes

If(Expression = 'Yes', Expression)

[matthewp]

in the table or in the list box?

[settu_periasamy]

If you want to select the 'yes' or 'no' data.. you need to look on calculated dimension

[sunny_talwar]

What is the expression you are using right now?

[jonas_rezende]

Hi, matthewp.

See if the solution in Thread the help - Re: Searching with Set Analysis.

Otherwise, an idea would be use expression in object ListBox.

Ex.:

Aggr(Sum(expression),dimension).

Hope this helps!

[marcus_sommer]

Try within a listbox:

aggr(YourExpression, YourDimension)

- Marcus

[matthewp]

=IF(Numb-Above(Numb) = 1 ),'Match','Check')

[sunny_talwar · Accepted solution]

Try creating a list box using this expression:

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