Is anyone aware of how we may search for a specific word in Qlik? For example, I only wish to search for companies with the word "law" and yet when I search I get "Lawn" "lawless" etc. I've tried a number of variations but none seem to work.
May be search using an expression
=Only(FieldName) = 'law'
=FieldName = 'Law'
Try a compound search like
Compound Search - demystified
Try with below expression
Thanks all, I couldn't quite get that to work though. I tried (* law *) and it worked to a point but ignored all those with law either at the start of the name or at the end.
try with *law* remove the white spaces in the search string start and end.
("* law *" | "law" | "* law" | "law *")
Brilliant, this is what i was looking for - thank you!
If your question is now answered, please flag the Correct answer and possible Helpful answers.
Never flag your own reply as Helpful, as it never is on your own topic.
If this topic is not answered yet, please make clear what part of this topic you still need help with.
Yes question answered. Sorry, first time using communities and thought I was marking swuel's answer as helpful not my own. thanks!
All good. Have a great weekend!
Would be nice to have a better search syntax for searching complete words in a string, though.
Retrieving data ...