topic Weightage Calculation in QlikView

Weightage Calculation

Wed, 01 Jun 2011 15:33:10 GMT

Hi Guys,

I am struggling with this Calculcation..

I am trying to calculate the Weightage equation in Qlikview in the above diagram. Can anyone help me?

I tried the following equations

=Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR])/Sum(TOTAl<DeliveryDocument_Key>Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range, DeliveryDocument_Key))

= (Sum(Total<DeliveryDocument_Key> DeliveryQuantity/[ST/KAR1]) * Sum(aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR])* Range),DeliveryDocument_Key)))/ (Sum(Total DeliveryQuantity/[ST/KAR1]))

could not get it correct. Can anyone help

I also need the Pivot Sum at the top correct which does not seem to be the case!

Regards

Sravan

Weightage Calculation

Wed, 01 Jun 2011 16:32:33 GMT

=Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1])/Sum(Total <DeliveryDocument_Key>(DeliveryQuantity/[ST/KAR1]))* sum(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key)),DeliveryDocument_Key))

Thought this is the Perfect answer. Still it does not work

Re: Weightage Calculation

Wed, 01 Jun 2011 17:13:16 GMT

I thought of attaching a sample... here it is

Hope someone can help now!

Thanks in Advance

Re: Weightage Calculation

Thu, 02 Jun 2011 04:59:52 GMT

Setanalysis experts..any help??

Re: Weightage Calculation

Thu, 02 Jun 2011 17:26:58 GMT

I am not getting this done..Any Help is really appreciated!