Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I think you can just create a calculated dimension and use
=If(NameField LIKE '*COM*', NameField)
or
If(WildMatch(NameField,'*COM*'), NameField)
I think you can just create a calculated dimension and use
=If(NameField LIKE '*COM*', NameField)
or
If(WildMatch(NameField,'*COM*'), NameField)
I am still not getting the value of the NameField on the chart. It just displays a dash.
=If(WildMatch(NameField,'*COM*'), NameField)
Cliff,
could you upload a small sample QVW?
Or some screenshots that show a list box of NameField and your current chart dimension?
I was finally able to get it to work with this:
=If(WildMatch([NameField], 'AMAZON*', 'EBAY*'),[NameField])