Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

puttemans
Valued Contributor

How to select a string variable based on a part of the contents of this variable


Hi,

I've got a string variable that basically contains 4 values ('coach', 'motor fuel', 'motor electrical' & 'other'). I want to select only the lines that contain the word 'motor' with a 'where' statement. I've tried the */~ & match routes, but without succes. Could anyone tell me which statement or character I should use to get all 'motor' lines selected?

Regards,

1 Solution

Accepted Solutions

Re: How to select a string variable based on a part of the contents of this variable

Johan

Have you tried the WildMatch() function ?

Best Regards,     Bill

2 Replies

Re: How to select a string variable based on a part of the contents of this variable

Johan

Have you tried the WildMatch() function ?

Best Regards,     Bill

puttemans
Valued Contributor

Re: How to select a string variable based on a part of the contents of this variable

Thank you, this works :-)