This content has been marked as final. Show 2 replies
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)|
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:
What is the best way to achieve this?