Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Weighted average

Hey Guys

I need to create Weighted Average for each country e.g

Columbia :  every row to multiply (H qty* H sul)/Sum(Total(H qty)

Capture.JPG

At the end this result is good but when i cancel the selection on Country Name the number is change i need to do aggr ?

Capture.JPG

need your help please see my app.

David

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Sum(HADERA_SUL_VALUE*HADERA_QTY)/Sum(TOTAL <COUNTRY_NAME> HADERA_QTY)

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Yes, you need to Aggr according the dimensions you need to weight

sunny_talwar

May be this:

Sum(HADERA_SUL_VALUE*HADERA_QTY)/Sum(TOTAL <COUNTRY_NAME> HADERA_QTY)

Anonymous
Not applicable
Author

Thank you for your help !