topic Re: Calculating weighted number in an expression in QlikView

Calculating weighted number in an expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Calculating weighted number in an expression

Anil_Babu_Samineni — Thu, 22 Jun 2017 15:38:36 GMT

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])

Re: Calculating weighted number in an expression

Kushal_Chawda — Thu, 22 Jun 2017 15:41:47 GMT

What is expression for "Number of Product"?

Re: Calculating weighted number in an expression

sunny_talwar — Thu, 22 Jun 2017 15:45:32 GMT

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

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

Re: Calculating weighted number in an expression

Kushal_Chawda — Thu, 22 Jun 2017 15:55:36 GMT

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