QlikView App Dev

[benjamincafeo]

So I am trying to do a search in a text string where I need to search for 'A' and ('B' or 'C')

• AA (no)     BB (no)     CC (no)   BC (no)    CB (no)
• AB (yes)   BA (yes)    AC (yes)   CA (yes)

I know that:

• (*B* ^ *C*) is B or C
• (*A* & *B*) is A and B
• (*A* & *C*) is A and C

I tried (*A* & (*B* ^ *C*)) but that did not work.

Can anyone show me how to do this or if it is even possible?

Thanks!

[sunny_talwar · Accepted solution]

This falls into swuehl‌ territory. He wrote this amazing article - Compound Search - demystified

[benjamincafeo]

Thanks!  It had exactly what I needed.