How do I filter a straight table w/ expressions?

[#1]

I have a field with the values 'Yes' or 'No'. How do I filter the table to only show 'Yes' values? Without creating a button or filter list.

What I've tried so far is to create a 'match' expression and then hide the null values. However the values converted to 0 or 1, and the 0 values wouldn't suppress.

The field name is: Rights/Options/Warrants

TIA.

[Anonymous]

Hi Ben,

Can you apply set analysis to one of the Expressions in your straight table:

{<[Rights/Options/Warrants]={'Yes'}>}

Charlie

[marcus_sommer · Accepted solution]

You could use a condition within the dimension like:

if([Rights/Options/Warrants] = 'Yes', [Rights/Options/Warrants])

and hiding NULL within the dimension. Or you used as respectively within each expression a set analysis like:

sum({< {Rights/Options/Warrants] = {'Yes'}>} AnyValueField)

and hiding NULL within the presentation tab.

- Marcus

[Anil_Babu_Samineni]

Use this,

if(wildmatch(FieldName.,'Yes')>0

      ,FieldName

      ,'Others'

      ) as <New Field Name>