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: 
Qlik_User007
Contributor
Contributor

Creating a Weighed Average in a Chart

Hi there, I'm extremely new to Qlik and am having problems replicating what is a very easy formula (SUMPRODUCT) in Excel in order to get the weighted average of some lines of data.  Attached is the table I have created, in order to check the data is correct before I then create graphs.  I have tried copying and pasting a few formula's such as AGGR, ONLY and set expression but I must be doing something wrong. 

I need a weighted average of the ct_mic column, which should be the total sum of ct_mic*Net Kg divided by total sum of Net Kg.

I also need to know how to exclude the 0 values from this calculation so that the weighted average is correct?

Help!

 

Labels (2)
0 Replies