2 Replies Latest reply: Aug 11, 2014 10:01 AM by Marco Wedel RSS

    weighted average with months

      Hi all,

       

      I have:

       

      Customer

      Qty

      Value

      Month

       

      I should calculate a weighted average of quantity starting with the month in which the Customer has been activated

       

      i.e

      Customer #1

      Month/Quantity

      Mar: 4

      Sep: 7

      Dec:10

       

      My weighted average is: 2,1 [(4+7+10)/10] 10 Months because I don't count Jan+Feb when the customer did not exist.

      I wonder how to make it in qlik...

      Any suggestion would be really appreciated! Thanks in advance!