associations not recognized

[Ray]

Hi all,

I'm having trouble creating associations between tables that are created with 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

[vunguyenq89]

Qlik automatically forms associations based on matching field names between 2 tables. Can you try renaming ID in Table A to CustomerName.ID and ID in Table B to OrderNumber.ID?

[Ray]

Matching field names is indeed one way for Qlik to recognize associations. In my case described above the field names do not match indeed.

However, Qlik should also be capable to interpret the actual records in the table and make associations accordingly correct? In my case described above I would expect Qlik to match 100% of all records even though the field names are not equal.