topic Re: Referencing Pivot Values in QlikView

Referencing Pivot Values

Anonymous — Wed, 02 Jan 2013 15:18:57 GMT

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

Re: Referencing Pivot Values

Gysbert_Wassenaar — Wed, 02 Jan 2013 15:22:39 GMT

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.

Re: Referencing Pivot Values

Anonymous — Wed, 02 Jan 2013 15:49:18 GMT

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?