Associations not recognized by Qlik for a Mendix database
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:
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.