Create 1 calendar with 2 date tables

[pauldamen]

Hi,

I have a script with a fact table and a different table with amounts. De fact table is linked to the Amount table with a ProjectID.

Also linked to the fact table is a master calendar based on the date field in the fact table. Now I have a date field in the Amount table as well (DateAmount).

How can I get this linked to the master calendar as well without creating loops etc? I searched the forum but couldn't find an answer that would help me fix it.

Thanks for your help!

Regards,

Paul

[arsal_90]

You can achieve this by link table

[rohit214]

hi,

do,

load

ID, Date,.... from facts;

left join

ID,

Date1 as Date

from amount fact;

so both the date come in single table.

hoope it helps you.

thanks

rohit

[crusader_]

Hi Paul,

Please check this very useful article http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Hope it helps.

Andrei

[pauldamen]

Hi Rohit,

If I do that I get lots of sync keys:

[pauldamen]

How do I create this link table with the sync keys I get below?

[arsal_90]

Below find the link table and if you still have problem then shared me your qvw with sample data

[crusader_]

Hi Paul,

To aviod Syn Keys you can create a table with all common fields inside, make a key using autonumber in parent tables and afterwards delete common fields from parent tables.

[pauldamen]

Thanks for the file.

Please find my file attached, hope you can help

Regards,

Paul

[rohit214]

hi,

can you share with me you code?

thanks

rohit