topic Re: Link Tables in QlikView

Link Tables

Wed, 26 Feb 2014 09:06:46 GMT

Hi Community,

I have a problem with linking tables.

I've got one table with columns named: Game-ID;Hometeam;Awayteam;Result. And another table with columns named: Team;Teamvalue

So I want, that when I click on a specific Team, for example ManchesterUnited, that all Games are shown where Manchester is either the Hometeam or the Awayteam.

At the moment the two tables stand alone in the table viewer. And when I click on Manchester nothing happens 🙂 How can I link them?

Thank you very much

Re: Link Tables

sundarakumar — Wed, 26 Feb 2014 09:11:48 GMT

U need some kind of common id field between the tables to link them, is hometeam in table 1 and team in table 2 are same,

if they are same they can be linked by renaming team as hometeam..

-Sundar

Re: Link Tables

sundarakumar — Wed, 26 Feb 2014 09:13:45 GMT

If they are same, you can link them while loading like,

load

team as Hometeam,

teamvalue

from src2.xlsx;

-sundar

Re: Link Tables

marcus_malinow — Wed, 26 Feb 2014 09:38:57 GMT

Hi Johannes,

how about loading a link table like this:

LINK:

LOAD

Game-ID,

Hometeam as Team

RESIDENT [fact table];

CONCATENATE (LINK)

LOAD

Game-ID,

Awayteam as Team

RESIDENT [fact table];

where [fact table] is the previously loaded table containing the results.

Marcus

Re: Link Tables

hic — Wed, 26 Feb 2014 10:08:05 GMT

You should definitely do what Marcus suggests.

From a theoretical perspective, it is the same problem as the one with a Canonical Date - although it is a date in one case and a Team in the other.

HIC