topic Re: Linking tables in App Development

Linking tables

Aspiring_Developer — Tue, 12 Jul 2022 10:23:54 GMT

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

Re: Linking tables

Mark_Little — Tue, 12 Jul 2022 10:38:52 GMT

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

Re: Linking tables

justISO — Tue, 12 Jul 2022 10:39:09 GMT

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.

Re: Linking tables

JHuis — Tue, 12 Jul 2022 11:16:28 GMT

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,between%20the%20multiple%20fact%20tables.

Re: Linking tables

vikasmahajan — Wed, 13 Jul 2022 09:01:47 GMT

Hi,

Refer simple demo created here and explained concepts.

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

Re: Linking tables

Aspiring_Developer — Wed, 13 Jul 2022 14:43:20 GMT

Hi @Mark_Little

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