Two table with same column values in one combo chart

[xyz2]

Hi,

I am loading two different tables via data editor in qlik. One table contains the columns "Team" and "Value1" the second table contains columns "Team" and "Value2". The Teams are the same, but the values of "Value1" and "Value2" are different.

So i want to create a Combo Chart in Qlik, where i display "Team" with "Value1" and "Value2". I thought, that Qlik can automatically recognize that "Team" in both tables are the same, but it didn't. Is there any way to create something like a foreign key or how can i tell Qlik, that Team from Table1 and Team from Table2 are the same?

Thanks in advance!

[qlikeers · Accepted solution]

Is the field name "team" EXACTLY the same in the two tables? Isn't there some space or something that distinguishes the names of these fields?

In the "Data model viewer" tables are connected by a line?