Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
For QV joins these two tables you have to add a common field Id_person.
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