Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
arjinram
New Contributor II

Linking multiple tables to master calender

Hi,

I am Trying to link 2 tables to a Master calendar, "Team" field is common between two tables and each table has dates which i want to link to calendar, when i try to link it its giving Synthetic keys,

qv.png

and even when i create a link table, linkages is not working, can any one help me to solve this.

Thanks in advance,

Arjin.

2 Replies
migueldelval
Valued Contributor

Re: Linking multiple tables to master calender

Hi Arjin,

Maybe you can try to rename "team" and link only for date.

Regards

Miguel del Valle de Gracia

manucamon
Valued Contributor III

Re: Linking multiple tables to master calender

Hi Arjin,

Try with a link table, to avoid circular references.

Productivity:

Autonumberhash128(Team&'-'&Calendar_Key) as Prod_Key,

Prod date,

Process type,

...

FROM...

Leaps_Master:

Autonumberhash128(Team&'-'&Calendar_Key) as Leaps_Key,

Case_num,

...

FROM...

LynkTable:

LOAD

Autonumberhash128(Team&'-'&Calendar_Key)  as Prod_Key,

Autonumberhash128(Team&'-'&Calendar_Key)  as Leaps_Key,

Calendar_Key

RESIDENT

Productivity;

LynkTable:

LOAD

Autonumberhash128(Team&'-'&Calendar_Key)  as Prod_Key,

Autonumberhash128(Team&'-'&Calendar_Key)  as Leaps_Key,

Calendar_Key

RESIDENT

Leaps_Master;

Load now your master calendar.

Regards!!

Community Browser