master calendar with 3 date with 2 tables

[Mahamed_Qlik]

Hi

I have 2 tables:

Tab1:

ID,

Trans_Date

Tab2:

ID

Start_Date,

End_Date

now I want to create master calendar with these 3 dates.

[Mark_Little]

Hi @Mahamed_Qlik 

You want a canonical calendar, Looks at this Article

https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578