3 Replies Latest reply: Mar 16, 2015 4:26 AM by Lathaa Vishwanthan RSS

    Variance calculation

      Hi all,

       

         I have a table like below :

          

      GroupIdTransIdPoints
      G11012
      G11028
      G11035
      G11040
      G11052
      G21064
      G21073
      G31084
      G31099
      G311010
      G411111
      G51120
      G51135
      G51140

       

      Each groupId has one or more transactionId tat in turn corresponds to some value . ie,Points

       

      Now I want to calculate the variance - Using the formula

      summation of ( X- mean(X)) ^ 2 / N

       

      For example for G1 we have 5 transaction so N=5  mean(points) = 17/5 =3.4

      Now the formula should be G1 =( (2-3.4)^2 + (8-3.4)^2 + (5-3.4)^2 +(0-3.4)^2 +(2-3.4)^2 ) /5

       

      Can someone help me out - how to achieve this kind of expression in Qlikview?

      do we have any variance function in QV!!

      If so, tell me how to use it for this kind of scenario?

       

      Regards

      Lathaa