Discussion board where members can get started with Qlik Sense.
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" ...
could you please send some sample data or file?
Thanks for the reply .. here is the example ..
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
The Crosstable Load
Then you can use Person field to filter all records where Person appears in any Role.