Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray
Contributor
Contributor

Associations not recognized by Qlik for a Mendix database

Hi all,

I'm having trouble creating associations between tables that are created within a Mendix application.

Mendix is a software-platform to build applications which uses a PostgreSQL database. Moreover, associations are always stored in a separate table as follows:

Table A:

IDCustomerName
111Albert
222Jane
333Ruby

 

Association table:

CustomerName.IDOrderNumber.ID
111555
222444
333666

 

Table B:

IDOrderNumber
444P57
555K13
666H192

 

A record in Table A can be associated with multiple records in Table B
A record in Table B can be associated with only one record in Table A
Hence, this is a classic 1-to-many relation.

Now my problem: When I try to associate Table A and/or Table B with the 'Association table' Qlik classifies this association with a red color and the tables are not associated properly. Is there a logical explanation for this behaviour?

I expect that Qlik classifies this association with a green color since it should be able to match 100,00% of all records.

I'm looking forward hearing back from you.

Regards, Ray

0 Replies