7 Replies Latest reply: Aug 24, 2012 6:02 AM by Stefan Wühl RSS

    EXCEL Sumproduct Functionality



      I'm trying to use Qlikview to solve a weighted average problem. As the example below,

      I would like to get an average GPA of (5*4+4*3+4*2+4*2+5*3)/(4+3+2+2+3)=4.5. How can i do it in QlikView?


      CourseScoreWeightWeight AVG
      Discr. Math43
      English Lit.42
      Comp. Sci.53


      Thanks very much.