Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Searching for a Specific word

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe

("* law *" | "law" | "* law" | "law *")

View solution in original post

12 Replies
sunny_talwar

May be search using an expression

=Only(FieldName) = 'law'

or

=FieldName = 'Law'

swuehl
MVP
MVP

Try a compound search like

(law)

Compound Search - demystified

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Try with below expression

=WildMatch('FieldName','*Seach String*')

krishnacbe
Partner - Specialist III
Partner - Specialist III

for example

WildMatch('FieldName','*Law*')

Not applicable
Author

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.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

try with *law* remove the white spaces in the search string start and end.

swuehl
MVP
MVP

Maybe

("* law *" | "law" | "* law" | "law *")

Not applicable
Author

Brilliant, this is what i was looking for - thank you!

oknotsen
Master III
Master III

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.

May you live in interesting times!