Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stephen_schrims
New Contributor

Help With Weighted Average - Qlik Sense

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

Tags (1)
1 Reply

Re: Help With Weighted Average - Qlik Sense

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])

Community Browser