Discussion Board for collaboration related to QlikView App Development.
Which is the best way to calculate the weighted average percentage of the following?
Thanks in advance!
@DanaL for calculation of weighted average you need to assign the weight for each category. What are the weights for each region?
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?
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.
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?