How to use WildMatch in a Chart

[cliff_clayman]

I have a simple chart that I would like to limit the results to names that are LIKE a certain name field.  I am not sure what the syntax needs to be for WildMatch.  I basically just want to do a LIKE statement, but I am not sure what the best way to limit my results would be.  I am looking to only return those values that match the statement.  Below is the basic structure of what I am looking to do:

If(NameField LIKE '*COM*', NameField)

[swuehl · Accepted solution]

I think you can just create a calculated dimension and use

=If(NameField LIKE '*COM*', NameField)

or

If(WildMatch(NameField,'*COM*'), NameField)

[cliff_clayman]

I am still not getting the value of the NameField on the chart.  It just displays a dash.

=If(WildMatch(NameField,'*COM*'), NameField)

[swuehl]

Cliff,

could you upload a small sample QVW?

Or some screenshots that show a list box of NameField and your current chart dimension?

[cliff_clayman]

I was finally able to get it to work with this:

=If(WildMatch([NameField], 'AMAZON*', 'EBAY*'),[NameField])