Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
DanaL
Contributor III
Contributor III

Weighted average - Sales vs. Budget

Hi People,

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

DanaL_0-1627048769561.png

Thanks in advance!

 

 

 

4 Replies
Kushal_Chawda

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

DanaL
Contributor III
Contributor III
Author

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!

 

 

 

Fischer54
Contributor
Contributor

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

 

 

DanaL
Contributor III
Contributor III
Author

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!