Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search for a text string but not another text string

In the search dialog box, how would you search for a text string like 'mac' but not for text string like 'machine' or don't show the results with 'machine'?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

If you want 'mac' but not 'mach', then you can use

(*mac* ^ *mach*)

HIC

View solution in original post

6 Replies
MayilVahanan

Hi

Please refer this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/16/text-searches

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks Mayil for your quick response.  Very useful link and info.  However, I still don't see how to do the search that I want.  Again, I want to search for 'mac' in the text, but I do not want to see results that have 'machine' or 'macon' or 'macdonald'.  Basically, I would like to search for records matching Text1 but don't show any records matching Text2, Text3, or Text4.

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

     =WildMatch(field, '*mac*') = 1 And WildMatch(field, '*machine*', '*macon*', '*macdonald*') = 0

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MayilVahanan

Hi

Try like this

Mac.PNG.png

*Mac

= WildMatch(Test,'*Mac') in Textbox

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
hic
Former Employee
Former Employee

If you want 'mac' but not 'mach', then you can use

(*mac* ^ *mach*)

HIC

Not applicable
Author

I tried this method too, but I kept running into runtime error.  The syntax makes sense.  I'll try again later.  In the meantime, I used the other suggestion since it is working.  Thanks.