# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP

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