topic Re: Linking multiple tables to master calender in QlikView

Linking multiple tables to master calender

Anonymous — Fri, 17 Jun 2016 08:38:12 GMT

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,

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

Thanks in advance,

Arjin.

Re: Linking multiple tables to master calender

migueldelval — Fri, 17 Jun 2016 09:33:46 GMT

Hi Arjin,

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

Regards

Miguel del Valle de Gracia

Re: Linking multiple tables to master calender

Anonymous — Fri, 17 Jun 2016 09:45:42 GMT

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!!