topic Re: Weighted average - Sales vs. Budget in QlikView

Weighted average - Sales vs. Budget

DanaL — Fri, 23 Jul 2021 14:00:53 GMT

Hi People,

Which is the best way to calculate the weighted average percentage of the following?

Thanks in advance!

Re: Weighted average - Sales vs. Budget

Kushal_Chawda — Fri, 23 Jul 2021 20:45:43 GMT

@DanaL for calculation of weighted average you need to assign the weight for each category. What are the weights for each region?

Re: Weighted average - Sales vs. Budget

DanaL — Sat, 24 Jul 2021 04:21:25 GMT

Hi @Kushal_Chawda,

Does it mean that I have to calculate it beforehand in the script or I can do it in he chart?

What would be the final expression, assuming sales weight is X, and budget weight is Y?

Thanks!

Re: Weighted average - Sales vs. Budget

Fischer54 — Tue, 27 Jul 2021 04:18:32 GMT

The average is the sum of all individual observations divided by the number of observations. In contrast, the weighted average is observation multiplied by the weight and added to find a solution.

myccpay

Re: Weighted average - Sales vs. Budget

DanaL — Sat, 24 Jul 2021 06:01:32 GMT

Hi @Fischer54 ,

Per table row - the calculation is correct.

So I only need it for the total line.

Is there any way to calculate the weight in the chart, or should it be done in the script?

Thanks!