Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
aslamshaikh
Contributor II
Contributor II

Data Modelling Across Multiple Table in Qlik Sense

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.

 

Labels (2)
1 Reply
Vishal_Gupta
Partner - Creator
Partner - Creator

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

 

If a post helps to resolve your issue, please accept it as a SOLUTION and leave a LIKE!