topic Re: Search for a text string but not another text string in QlikView

Search for a text string but not another text string

Thu, 17 Oct 2013 14:23:01 GMT

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'?

Re: Search for a text string but not another text string

MayilVahanan — Thu, 17 Oct 2013 14:27:47 GMT

Please refer this

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

Re: Search for a text string but not another text string

Thu, 17 Oct 2013 14:40:49 GMT

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.

Re: Search for a text string but not another text string

jonathandienst — Thu, 17 Oct 2013 14:43:22 GMT

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

HTH

Jonathan

Re: Search for a text string but not another text string

MayilVahanan — Thu, 17 Oct 2013 14:45:27 GMT

Try like this

*Mac

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

Re: Search for a text string but not another text string

hic — Thu, 17 Oct 2013 14:46:39 GMT

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

(*mac* ^ *mach*)

HIC

Re: Search for a text string but not another text string

Thu, 17 Oct 2013 15:04:47 GMT

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.