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