Linking date fields to master calendar dates

[Bob07]

Hello,
I need help. I have 2 date fields in a load script as shown below. I also have a master calendar QVD with dates. 
How do I link the two dates in the UD table to the master calendar so that when I select Cal year or cal yearquarter, the line charts will display request and delivery data for the cal date selected?
UD:
LOAD 
    "request date",
    "delivery date",
    Otherfields
    Otherfields

From qvd. 

Calender:
%PK_calender
Caldate
Calyear
Clayearquarter
Calyearmonth

From qvd. 

Thank you. 

[Oleg_Troyansky]

Hi,

The solution to this problem is called "the canonical date". Read this blog post for details:

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

Cheers,

[rwunderlich]

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

-Rob

[Oleg_Troyansky]

I was looking for that one, couldn't find it.