Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
puttemans
Specialist
Specialist

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
Anonymous
Not applicable

Johan

Have you tried the WildMatch() function ?

Best Regards,     Bill

View solution in original post

2 Replies
Anonymous
Not applicable

Johan

Have you tried the WildMatch() function ?

Best Regards,     Bill

puttemans
Specialist
Specialist
Author

Thank you, this works 🙂