Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
djugal
Contributor III
Contributor III

Linking three entities in MDM Data Model

Hi,

 

 Have an issue where I need to check and join 3 entities. I want Country names of students to be displayed but only those countries which are in EMEA

Student (Name Status CountriesID)

AllCountries (ID Name)

EMEACountries (Name Area Nation)

 

So now for my column Student / CountriesID join to AllCountries / ID

Then have a FK filter AllCountries / ID contains EMEACountries / Name

 

 

but I get the error saying that 'CONTAINS' support not implemented for field to field comparison.

 

Can you tell me how I can do this join

 

Labels (3)
1 Reply
Anonymous
Not applicable

Hello,

If we got your question right, .since our tMDMInput works on pro entity base and you could get the fk id and then query all the entity with that fk. Let us know if it is what you are looking for.

Best regards

Sabrina