This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying to calculate the weighted average rate for the below sample data in which i am showing only one product as A which has multiple customers having different rates and amount.
1. Wght Avg Amt = Rate * Amount
2. Wght Avg Rate = Sum of Wght Avg Amt / Sum of Amount
Output I am looking for is Productwise Wieghted Average Rate as follows:
Have product as dimension.
Expression as =Sum(aggr(Avg(Amount*Rate),Acc))/Sum(Amount)
Hope it helpsCelambarasan
View solution in original post
have a look at the attachment. hope this helps.
Thanks Celambarasan Adhimulam.