How to create an "OR" filter

[#1]

Please help!

I like to create a filter with OR relationship built in ...

if I choose name = "ABC" then will give me sales personal name = "ABC" or engineer name ="ABC"

thanks!

[Digvijay_Singh]

I think you want output as attached, I used Robin' expression, the table responds to the selection in customer field as you are expecting, I concatenated order no when rows are repeating, couldn't find how to show them as separate rows as only() will ignore them due to multiple results.

[Anonymous]

it is possible...

expression:

if(
count(
{

< BILLTO= P({< PAYER=,SHIPTO= >} Customer)  >

+ < PAYER= P({< BILLTO=,SHIPTO= >} Customer)  >

+ < SHIPTO=P({< PAYER=,BILLTO=  >} Customer)  >

}  ORDERS)>0,ORDERS)

dimension:

ORDERS (hidden)

------------------------------------------

btw. --> another approach by Barry Harmsen:

http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/