Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mattbowers
New Contributor

Referencing Pivot Values

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)
A16-18100m7410.4310.85
B12-14400m8464.2165.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
A16-18100m7410.92+0.07
B12-14400m8465.01-0.20

What is the best way to achieve this?

Thanks

Matt

Tags (1)
2 Replies

Re: Referencing Pivot Values

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.


talk is cheap, supply exceeds demand
mattbowers
New Contributor

Re: Referencing Pivot Values

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?

Community Browser