topic Re: Search Object multiple term "AND" rather than "OR"? in QlikView

Search Object multiple term "AND" rather than "OR"?

markadavies — Mon, 01 Feb 2016 15:17:17 GMT

Hi,

As I understand it, if multiple search terms are input to a Search Box, results will be displayed for ANY matching term.

Is it possible to make the search return only where BOTH terms are found?

As an example, if I have 3 rows containing the following text ...

1 "Cheese"

2 "Onion"

3 "Cheese and Onion"

If I enter into a Search Box "Cheese Onion", I believe that I will get all 3 rows returned.

How can I enter a search where only the 3rd row "Cheese and Onion" is returned?

Many Thanks

Mark

Re: Search Object multiple term "AND" rather than "OR"?

sunny_talwar — Mon, 01 Feb 2016 15:29:28 GMT

See if this application is helpful.

Re: Search Object multiple term "AND" rather than "OR"?

swuehl — Mon, 01 Feb 2016 15:37:42 GMT

Try a compound search

(*cheese* & *onion*)

Re: Search Object multiple term "AND" rather than "OR"?

markadavies — Mon, 01 Feb 2016 16:01:30 GMT

Thanks swuehl, perfect!

The Compound Search - demystified link is very helpul !

Re: Search Object multiple term "AND" rather than "OR"?

markadavies — Mon, 01 Feb 2016 16:03:09 GMT

Thanks Sunny

Very clever, but I am particularly looking to enable multiple search terms over a number of fields - it looks like the compound search is what I am looking for

Really like your example though!