1 Reply Latest reply: Jan 7, 2018 4:47 PM by Sunny Talwar RSS

    Help With Weighted Average - Qlik Sense

    Stephen Schrimshaw

      PLEASE CAN YOU HELP. I NEED TWO MEASURES:

      1)   ONE TO BE ABLE TO CALCULATE IGNORING SELECTIONS MADE TO ASSESSMENT ID.

      2) ONE TAKING INTO ACCOUNT ALL SELECTIONS MADE

       

      Assessment ID

      Product Value

      Number of Products Deep

      Number of Products High

      Number of Products Wide

      Case Value

       

       

       

       

       

       

      1

      0.1

      6

      1

      2

      1.2

      2

      0.2

      8

      1

      1

      1.6

      3

      0.3

      7

      1

      2

      4.2

      4

      0.2

      10

      1

      4

      8

      5

      0.15

      6

      1

      1

      0.9

       

       

       

       

      TOTAL

      15.9

       

       

      CASE VALUE = Product Value x Number of Products Deep x Number of Products High x Number of Products Wide

      WEIGHTED AVERAGE  = SUM(Case Value) / COUNT (Assessment ID)

      WEIGHTED AVERAGE  = 15.9 / 5 = 3.18

        • Re: Help With Weighted Average - Qlik Sense
          Sunny Talwar

          Are these needed in KPI Object? Try these:

           

          1) =Sum({<[Assessment ID]>} [Product Value] * [Number of Products Deep] * [Number of Products High] * [Number of Products Wide])/Count({<[Assessment ID]>}DISTINCT [Assessment ID])

           

          2) =Sum([Product Value] * [Number of Products Deep] * [Number of Products High] * [Number of Products Wide])/Count(DISTINCT [Assessment ID])