I know this subject has already been discussed several times on this forum, but the last thread was an year ago, so I will give it a shot.
I currently have a map containing 2 layers:
Companies
Contacts
These two entites are linked to each other (1 Contact always has 1 Company and 1 Company can have 0..n Contacts).
When selecting in my map (Using the lasso), I would like to have the list of all the Companies & Contacts in a specific area. The result should be the following :
All Contacts (in the selected area) & All their related Companies (No matter where they are located) + All Companies (in the selected area) & All their related Contacts (No matter where they are located).
I read that it was not possible to select multiple layers at once. Therefore, I was thinking about creating a new column, being the aggregation of both Companies & Contacts, but this would probably mess the Qlik associativity up.
Does any one have an idea of how I could handle this?
