Linking tables

[Aspiring_Developer]

Hello All,

I have below data model in my script :-

I have three tables and I have created an composite key on the basis of date and Brand.

I wish to create master calendar and it should be linked with the dates in the model.

As of now I have created composite key in all tables and in the remaining tables, I have renamed the fields brand and date to avoid synthetic keys.

Now, I am not able to understand how should I link the dates with master calendar because I have renamed the date fields in other two tables .I wish to show the single date and month filters in front end that should work for entire model.

Can anyone please help ?

Thanks in advance

[Mark_Little]

Hi there,

You would need to move the dates and keys to as link table, then link the master calendar. Here is a helpful article to take through it.

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

[justISO]

Hi, maybe create a separate, 4th, calendar table, where related field would be 'Date', so it will 'link' by this field with table 'Total Market', and from it with all other tables.

[JHuis]

You could 2 things: create a link table or concatenate table. This is explained in the link below.

If you have any question i could help you

https://www.ometis.co.uk/concatenate-link-tables-qlik/#:~:text=A%20link%20table%20resolves%20the,bet....

[vikasmahajan]

Hi,

Refer simple demo created here and explained concepts.

https://community.qlik.com/t5/Qlik-Sense-Documents/link-table/ta-p/1883375

[Aspiring_Developer]

Hi @Mark_Little 

I am not able to practically execute this approach. Can you please help with a sample code ?