Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to connect one dimension to different variables ?

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 ?

RaceFirst personSecond persontirth person
Race 1FrederikLouisWillem
Race 2JosAnnaPol
Race 3JefJosMaria
Race 4LouisJefAnna

NameAgeGender
Frederik20m
Jos25m
Jef27m
Louis28m
Anna30f
Willem35m
Maria60m
Pol54m
1 Solution

Accepted Solutions
ziadm
Specialist
Specialist

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

View solution in original post

2 Replies
sergio0592
Specialist III
Specialist III

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

ziadm
Specialist
Specialist

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