topic Re: Searching for a Specific word in QlikView

Searching for a Specific word

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Searching for a Specific word

sunny_talwar — Thu, 19 May 2016 16:21:37 GMT

May be search using an expression

=Only(FieldName) = 'law'

=FieldName = 'Law'

Re: Searching for a Specific word

swuehl — Thu, 19 May 2016 16:22:31 GMT

Try a compound search like

(law)

Compound Search - demystified

Re: Searching for a Specific word

krishnacbe — Thu, 19 May 2016 16:23:55 GMT

Hi,

Try with below expression

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

Re: Searching for a Specific word

krishnacbe — Thu, 19 May 2016 16:24:33 GMT

for example

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

Re: Searching for a Specific word

Thu, 19 May 2016 16:48:39 GMT

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.

Re: Searching for a Specific word

krishnacbe — Thu, 19 May 2016 17:52:16 GMT

Hi,

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

Re: Searching for a Specific word

swuehl — Thu, 19 May 2016 17:55:28 GMT

Maybe

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

Re: Searching for a Specific word

Fri, 20 May 2016 08:54:32 GMT

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

Re: Searching for a Specific word

oknotsen — Fri, 20 May 2016 08:59:09 GMT

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.

Re: Searching for a Specific word

swuehl — Fri, 20 May 2016 09:03:14 GMT

You're welcome.

Would be nice to have a better search syntax for searching complete words in a string, though.

Re: Searching for a Specific word

Fri, 20 May 2016 09:03:30 GMT

Yes question answered. Sorry, first time using communities and thought I was marking swuel's answer as helpful not my own. thanks!

Re: Searching for a Specific word

oknotsen — Fri, 20 May 2016 09:05:03 GMT

All good. Have a great weekend!