topic Re: How to connect one dimension to different variables ? in QlikView

How to connect one dimension to different variables ?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to connect one dimension to different variables ?

sergio0592 — Thu, 02 Mar 2017 16:42:21 GMT

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

Re: How to connect one dimension to different variables ?

ziadm — Thu, 02 Mar 2017 16:53:40 GMT

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