Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP
MVP

Re: Searching for a Specific word

Maybe

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

12 Replies

Re: Searching for a Specific word

May be search using an expression

=Only(FieldName) = 'law'

or

=FieldName = 'Law'

MVP
MVP

Re: Searching for a Specific word

Try a compound search like

(law)

Compound Search - demystified

krishnacbe
Valued Contributor III

Re: Searching for a Specific word

Hi,

Try with below expression

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

krishnacbe
Valued Contributor III

Re: Searching for a Specific word

for example

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

Not applicable

Re: Searching for a Specific word

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
Valued Contributor III

Re: Searching for a Specific word

Hi,

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

MVP
MVP

Re: Searching for a Specific word

Maybe

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

Not applicable

Re: Searching for a Specific word

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

oknotsen
Honored Contributor III

Re: Searching for a Specific word

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!