Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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
I thought of attaching a sample... here it is
Hope someone can help now!
Thanks in Advance
Setanalysis experts..any help??
I am not getting this done..Any Help is really appreciated!