How to connect one dimension to different variables ?

[#1]

I have two tables, in one table the rows represents races, the other table is a description of each participant competing in the race. When i select a race i would want to see the description of the poeple attending the race.

So when selecting race 2 i want to see the Age and Gender of Frederik, Louis and Willem in table 2

How do i program this in qlikview ?

Race	First person	Second person	tirth person
Race 1	Frederik	Louis	Willem
Race 2	Jos	Anna	Pol
Race 3	Jef	Jos	Maria
Race 4	Louis	Jef	Anna

Name	Age	Gender
Frederik	20	m
Jos	25	m
Jef	27	m
Louis	28	m
Anna	30	f
Willem	35	m
Maria	60	m
Pol	54	m

[sergio0592]

For QV joins these two tables you have to add a common field Id_person.

[ziadm · Accepted solution]

Hi

user Cross Table Transformation to Transform the first Table and change the field to link two table by the Person Name

Attached Data and QVW file

Thanks