Calculating weighted number in an expression

[Anonymous]

Dear All,

I am working on a qlikview application which aims to calculate the aggregate work in progress `(WIP) in our suppliers. The calculus of their work in progress is the Number of Products already demanded (column 2) divided by the supplier´s month capacity (column 3).

However, we want also to calculate the weighted WIP (WWIP), which is done by the sum of each supplier´s WIP times it´s number of products divided by the total number of products.

In the case expressed by the table below, we have the following calculation:

1000*2,5 + 500 * 1,67 + 700* 2,33 + 300*0,3 / (1000+500+700+300) = 2,02

Can anyone help me doing the WWIP in a single expression?

Regards,

[Anil_Babu_Samineni]

May be this?

((Sum({<Supplier = {A}>} [Number of Products]) * Sum({<Supplier = {A}>}WIP)) +

(Sum({<Supplier = {B}>} [Number of Products]) * Sum({<Supplier = {B}>}WIP)) +

(Sum({<Supplier = {C}>} [Number of Products]) * Sum({<Supplier = {C}>}WIP)) +

(Sum({<Supplier = {D}>} [Number of Products]) * Sum({<Supplier = {D}>}WIP))) / Sum(TOTAL [Number of Products])

[Kushal_Chawda]

What is expression for "Number of Product"?

[sunny_talwar]

You need WWIP in a KPI or text object? May be try like this

Sum(Aggr((Expression4NumberOfProduct * Expression4WIP)/Expression4NumberOfProductWithTOTALQualifier, Supplier))

[Kushal_Chawda]

sum(aggr((Expression of Number of Product)*sum(distinct Weight),Supplier))/(Expression of Number of Product)