Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How to use WildMatch in a Chart

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)

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I think you can just create a calculated dimension and use

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


or


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

View solution in original post

4 Replies
swuehl
MVP
MVP

I think you can just create a calculated dimension and use

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


or


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

cliff_clayman
Creator II
Creator II
Author

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

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

swuehl
MVP
MVP

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
Creator II
Creator II
Author

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

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