topic Re: How to use WildMatch in a Chart in QlikView

How to use WildMatch in a Chart

cliff_clayman — Wed, 01 Jun 2016 14:05:48 GMT

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)

Re: How to use WildMatch in a Chart

swuehl — Wed, 01 Jun 2016 15:23:06 GMT

I think you can just create a calculated dimension and use

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

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

Re: How to use WildMatch in a Chart

cliff_clayman — Wed, 01 Jun 2016 15:27:35 GMT

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

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

Re: How to use WildMatch in a Chart

swuehl — Wed, 01 Jun 2016 15:40:26 GMT

Cliff,

could you upload a small sample QVW?

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

Re: How to use WildMatch in a Chart

cliff_clayman — Wed, 01 Jun 2016 15:48:23 GMT

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

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