Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
Thanks,
Andrew
May be search using an expression
=Only(FieldName) = 'law'
or
=FieldName = 'Law'
Hi,
Try with below expression
=WildMatch('FieldName','*Seach String*')
for example
WildMatch('FieldName','*Law*')
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.
Hi,
try with *law* remove the white spaces in the search string start and end.
Maybe
("* 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.