Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner
Partner

Create 1 calendar with 2 date tables

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

Capture.PNG.png

18 Replies
arsal_90
Creator III
Creator III

You can achieve this by link table

rohit214
Creator III
Creator III

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_
Partner
Partner

Hi Paul,

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

Hope it helps.

Andrei

pauldamen
Partner
Partner
Author

Capture.PNG.pngHi Rohit,

If I do that I get lots of sync keys:

pauldamen
Partner
Partner
Author

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

arsal_90
Creator III
Creator III

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

crusader_
Partner
Partner

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
Partner
Partner
Author

Thanks for the file.

Please find my file attached, hope you can help

Regards,

Paul

rohit214
Creator III
Creator III

hi,

can you share with me you code?

thanks

rohit