Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to build "OR" relation filter in the dashboard?

I like to find a way to create a filter with OR function --

when I choose a person name = "ABC" .. it will give me sales person name = "ABC" or engineer name = "ABC" ...

Please help!

Thanks!

3 Replies
agni_gold
Specialist III
Specialist III

could you please send some sample data or file?

Not applicable
Author

Thanks for the reply .. here is the example ..

swuehl
MVP
MVP

You can transform your Detail table from a cross table to a straight table using CROSSTABLE LOAD prefix:

CROSSTABLE( Role, Person)

LOAD ORDERS, BILLTO, PAYER, SHIPTO

FROM ....;

The Crosstable Load

Then you can use Person field to filter all records where Person appears in any Role.