I would like to link these two fields coming from the same table to another table. The value in the two fields are the same and that's why i want to link them to the same table. This is an example below.
Games Table
| Home Team | Away Team | Home Goals | Away Goals |
|---|
| Man United | Arsenal | 2 | 1 |
| West Ham | Man United | 0 | 1 |
I want to create an application where you can filter on teams. I know i have to create a table called "Teams" of all the 20 premier league teams, therefore i would like to link HomeTeam and AwayTeam to the teams table but of course the field have to be different names. Is there a smart way i can trick QlikSense to link these two fields to the same table.
I have tried to create HomeTeam as a table of its own and Away Team as it's own and link them in their individual tables and then left join then in a new table but I cannot left join them because if i use the FK as a left join it will give me the example below
| Home Team | Away Team | Home Goals | Away Goals |
|---|
Man United Man United 2 1
Anyone please help.
Thanks,
Vic
