2 Replies Latest reply: Jan 2, 2013 10:49 AM by Matthew Bowers RSS

    Referencing Pivot Values

    Matthew Bowers

      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