Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Associations in Qlik Sense

I have several "transaction" tables which have a date field in them. I also have a date look up table which tells me which company specific time period a date belongs to. I therefore need to associate the date fields in the transaction tables with the date field in the look up table. Currently the date fields in the transaction tables have different names to the date field in the look up table. When I try and create the associations in the Data Manager it starts breaking some other associations (I have 6 different transaction tables).

Is there any way to create associations in the load script?

Or do I need to ensure all of the date fields are called the same thing?

Tags (1)
2 Replies
rittermd
Honored Contributor

Re: Associations in Qlik Sense

In order to associate the tables the field names have to be the same.

You can modify this in the script using an alias for each field that you want to associate.

ogster1974
Honored Contributor II

Re: Associations in Qlik Sense

You can do as mark suggests and name all your date fields the same and let qlik associative data model do the rest or you can set up a master calendar and link the transaction dates to it using set analysis when you create specific charts. More work with the second option but you will have more flexibility.

Regards

Andy