Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cliff_clayman
Contributor

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
MVP
MVP

Re: How to use WildMatch in a Chart

I think you can just create a calculated dimension and use

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


or


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

4 Replies
MVP
MVP

Re: How to use WildMatch in a Chart

I think you can just create a calculated dimension and use

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


or


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

cliff_clayman
Contributor

Re: How to use WildMatch in a Chart

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

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

MVP
MVP

Re: How to use WildMatch in a Chart

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
Contributor

Re: How to use WildMatch in a Chart

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

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

Community Browser