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 have the following straight table
For each area, i have Deliveries and orders rexpectively. i have to calculate another column which gives % delivered
the formula for that is [Deliveries value of each vehicle] divided by the total value 2337. this total is not the expression total. it is the sum of all rows.
For eg. my first column calculation is 30/2337 = 1.28%
calculation for deliveries is sum(order_delivered)
Is this possible?
if so, can someone please help me with expression?
i tried using Total & All function, but it is not giving the sum of rows value. it is giving expression total of that column.
sum(TOTAL Aggr(sum(order_delivered),Area, Vehicle))
View solution in original post
Try like this for % Delivered
And then give relative