Qliksense: Calendar Problem: Need to connect three Data sources with Calendar

[#1]

Hi,

I have three type of data:-

1) Actual Data with Start and End Date(TImestamp)

2) Planned Data with Start Date (Timestamp)

3) Forecast Data with Start Date(Timestamp)

I loaded 6 years to till date Calendar and renamed the Start Date in every type of data so that there is association between all the tables but synthetic key is coming.

Also when I am applying LEFT KEEP , it is only showing today;s date.

Please help me out with this. reddys310‌ Scripting‌

I am attaching QVF file as well as data.

Regards

Rohit Parimal