Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
markadavies
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a compound search

(*cheese* & *onion*)

See also

Compound Search - demystified

View solution in original post

4 Replies
sunny_talwar

See if this application is helpful.

swuehl
MVP
MVP

Try a compound search

(*cheese* & *onion*)

See also

Compound Search - demystified

markadavies
Contributor III
Contributor III
Author

Thanks swuehl, perfect!

The Compound Search - demystified link is very helpul !

markadavies
Contributor III
Contributor III
Author

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!