Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!