Common Calendar for Multiple dates in Multiple tables

[#1]

Hello Friends.

I have one requirement  in Qlikview for HR Data Set where I have multiple Date field in 2 different tables. (Requisition data & Candidate Data)

Now I want to create a common calendar corresponding to both the tables. Somehow I tried concatenation statement against each date field but that is duplicating my data. Please help me with the solution of how to implement common calendar concept in this case. If possible through any QVW file. I am attaching the sample data sheet for same.

Thanks in Advance.

Regards

Amit Sharma

[ahaahaaha]

Hi,

May be this help?

Canonical Date‌

Regards,

Andrey