Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Is there any way to manually associated tables?

I have a very traditional normalised SQL Server database that uses a common Lookup (Reference table).  Qlik Sense attempts to create Associations and is successful on the main tables, however it fails on the reference table and I need to force the association.

Any ideas please?

1 Reply
Highlighted
oknotsen
Honored Contributor III

Re: Is there any way to manually associated tables?

Rename (in the preceding load part of your script) the key fields (by using AS) to have exactly the same name.

Qlik has a pretty clear standard if it comes to association: If it has the same name, it is the same thing. If it does not have the same name, it is not the same thing.

May you live in interesting times!