topic Weighted average in QlikView

Weighted average

Mon, 02 Nov 2009 20:38:41 GMT

Hi All, I have the following problem: my information drills down in country-region-Channel. I have the variable "Physical Distribution" per country-region-channel but i want to see that variable in just for "Country". It must be an average, but a weighted average (weighted by Volume). How can I code that?

example.

Chile -> Santiago --> Traditional : physical distribution = 90 , Vol = 200.000

Chile -> Santiago --> H & S : physical distribution = 56 , Vol = 100.000

Chile -> Santiago --> Modern : physical distribution = 80 , Vol = 20.000

Physical Distribution for Santiago : ( 200.000/320.000 * 90 + 100.000/320.000 * 56 + 20.000/320.000 * 80)

Weighted average

Mon, 02 Nov 2009 21:11:11 GMT

Hi,

Please, look into an attached example.

I hope it will help you.

Kind regards,

JTPro

Weighted average

Oleg_Troyansky — Tue, 03 Nov 2009 02:08:10 GMT

Try this:

sum(PD * Volume) / sum(Volume)

cheers,

Weighted average

Tue, 03 Nov 2009 20:47:56 GMT

Thank Janusz, your example was very helpful. I adapted it and everything seems to be working right.

Weighted average

Wed, 24 Nov 2010 12:16:34 GMT

I'm trying to accomplish something similar, but with a weighted time average and I just can't manage to get it to work. I got data with the structure like the attachment and I want the weighted average waiting time per skill. I've tried using both a <TOTAL> and an AGGR, anybody got any ideas?

Weighted average

Thu, 25 Nov 2010 13:03:29 GMT

Figured out the problem was in my set analysis and not in my formula, <TOTAL> worked fine.