master calendar

[Dolly123]

if we have 2 fact tables both have dates individual and we dont want to join the tables we need separte table only common should be master calendar so  should connected with master calendar how we can do it

[vikasmahajan]

Hi,

You can implement the link table :

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

Vikas

[Hania]

Hi,

Yes you can do it with the help of Link table  (also Knowns as Canonical Dates).

Step1: after loading the data you need to create Bridge Table for both the Dates  and Flag as well  with the help of primary key.

Step2: concatenate table of Both Dates .

Step3:  create master calendar  for Dates

Here is an Code for Bridge Table of my sample Data you can refer it .

LinkTable:
Load
CustID,
Date("Actual Delivery Date" ,'DD/MM/YYYY') as Date,
'Actual Delivery Date' as flag
Resident SALESDETAILS;

Concatenate

Load
CustID,
Date("Promised Delivery Date" ,'DD/MM/YYYY') as Date,
'Promised Delivery Date' as flag
Resident SALESDETAILS;

mastercalender:
load
Date as Date
Resident LinkTable;

Use Date and Primary Key of your Data. 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Dolly123]

I have 2 tables for resident how we can do 

[rwunderlich]

Please find a downloadable example here:

Qlikview Cookbook: Tutorial - Using Common Date Dimensions https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob