Data Modelling Across Multiple Table in Qlik Sense

[aslamshaikh]

Hello Team,

Hope you are doing well!

I am new to Qlik Sense and struggling in data modelling part.

I have three table "A", "B" & "C" all three tables contains a column name as "key" and table "A" and "B" contains a column as "Date_A" and "Date_B".

I want to create a common date field to use across all the sheets and column "key" should have relationship across all the three table.

Please suggest me how can i prepare a relationship between this three table ?

So far I manage to make a relationship between all three tables for column "key" but not understanding how to make relationship between table "A" and "B" for having common date.

[Vishal_Gupta]

Hi @aslamshaikh,

This seems like a Canonical Calendar/Link Table data model use case. 

Here are some reference links for you:

1. Canonical Date - Qlik Community - 1463578
2. https://youtu.be/8vfzcd6rIRw
3. #24 📆 Canonical calendar in Qlik Sense — Qreatic

Do let me know if these help