Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a SQL database (containing athletics results) that I connect to via Qlikview. I created a Pivot table with the following to show the minimum and average winning times based on the other 4 variables.
race_track | race_type | race_distance | race_temperature | min (race_winning_time) | avg (race_winning_time) |
---|---|---|---|---|---|
A | 16-18 | 100m | 74 | 10.43 | 10.85 |
B | 12-14 | 400m | 84 | 64.21 | 65.11 |
What I want to achieve is to use these min (race_winning_time) and avg (race_winning_time) values and compare them against race times in a secondary table to show how a participants time compares to the average, e.g:
race_track | race_type | race_distance | race_temperature | participant_time | diff_from_avg |
---|---|---|---|---|---|
A | 16-18 | 100m | 74 | 10.92 | +0.07 |
B | 12-14 | 400m | 84 | 65.01 | -0.20 |
What is the best way to achieve this?
Thanks
Matt
You cannot reference cell values of one chart in another chart. You'll have to add the same expression to the second pivot table (or use it inside your diff_from_avg expression) or better yet create a variable that contains your expression and use the variable in both pivot charts.
Thanks, if I add the avg (race_winning_time) to the second pivot table it shows each participant's time as the avg. I guess this is 'correct' as I've added another variable to the pivot so it recalculates the avg.
How do I create a variable just based on selected original columns?