String Search "and" "or"

[SevillaFe]

Hello, I need your help with the String search.

a text string separated by spaces contains features of my products and I would like to know how I can do a search including "or" and "and"., i.e.:

Product 1: AA BB CC DD EE FF GG

My search: which Products have the features AA and (BB or DD)?

I would like to use "and" / "or" when I search in the text string...

please help me.... 

Thank you!!

[Edvin]

Try this:

=IF(Match(Product,AA) AND (Match(Product,BB) OR Match(Product,DD)), Product)

[SevillaFe]

Hi Edvin!! thank you very much for your answer!!

do you know how could do that using the filter (search in listbox)?

i.e.,  when I use "-" then excludes results from my search 

then if I search AA and CC or BB, what should insert in the listbox? +AA +BB??

Thank you

[JordyWegman · Accepted solution]

Hi,

You can use the Qlik Sense Search bar for this. This will find all space separated requests.

Jordy

Climber