topic Re: Calculating Total Weight from Product Masterdata Weight * Order Quantity in QlikView

Calculating: Total Weight = Product Masterdata Weight x Order Quantity

coskunist — Tue, 21 May 2013 07:01:07 GMT

Hello Gurus,

I need your help. I want to calculate: total weight of orders from product master data and order quantity.

My model is like below:

I used a chart formatted as pivot, I have a calculated expression:

Total Weight = Sum(open order quantity) * Sum(UNIT WEIGHT)

The issue is that, when I drill up to GROUP1 as below, it gives wrong value.

For example: 21 x 30, 37 = 637,82. But I need to calculate as 38,89 x 10 + 22,30 x 10 = 611,9

jonathandienst — Tue, 21 May 2013 07:07:58 GMT

Something like this, perhaps:

Sum(Aggr(Sum([open order quantity]) * Sum([UNIT WEIGHT]), [MATERIAL CODE], GROUP1))

Hope that helps

Jonathan

coskunist — Tue, 21 May 2013 07:22:30 GMT

I used the formula as below, but it still calculates wrongly:

SUM( AGGR ( SUM([OPEN ORDER QUANTITY]), [MATERIAL CODE] ) ) * SUM( TOTAL <[MATERIAL CODE], GROUP1> [UNITWEIGHT] )

coskunist — Tue, 21 May 2013 16:12:40 GMT

My friend Serhan solved my problem.

We need to do as : SUM ( OPEN_ORDER_QTY x UNITWEIGHT )