topic Re: Linking date fields to master calendar dates in App Development

Linking date fields to master calendar dates

Bob07 — Tue, 15 Apr 2025 15:57:33 GMT

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.

Re: Linking date fields to master calendar dates

Oleg_Troyansky — Tue, 15 Apr 2025 16:11:19 GMT

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,

Re: Linking date fields to master calendar dates

rwunderlich — Tue, 15 Apr 2025 17:27:15 GMT

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

-Rob

Re: Linking date fields to master calendar dates

Oleg_Troyansky — Tue, 15 Apr 2025 17:34:34 GMT

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