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:
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?
