Associations not recognized by Qlik for a Mendix database

Ray — Wed, 14 Aug 2019 13:33:06 GMT

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:

ID	CustomerName
111	Albert
222	Jane
333	Ruby

Association table:

CustomerName.ID	OrderNumber.ID
111	555
222	444
333	666

Table B:

ID	OrderNumber
444	P57
555	K13
666	H192

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

topic Associations not recognized by Qlik for a Mendix database in Connectivity & Data Prep

Associations not recognized by Qlik for a Mendix database