Dear Qlik Family,
NOTE: Plz give Solution on Frontend (in Chart Expressions)
I have a table as Follows
OrderNo,TruckNo,Arrival Time, Pay Load Qty
A, 1, 10.3, 7.6
A, 2, 10.6, 9
A, 3, 10.8, 6
A, 4, 11.5, 9
A, 5, 13.0, 8.5
B, 1, 10.3, 7.6
B, 2, 10.8, 6
B, 3, 11.5, 9
B, 4, 13.0, 8.5
B, 5, 13.5, 8
What I want is a New field (definition: Payload qty Arrived in prev 1 Hour for each Order No and each truck). This field will have value as sum of all the Pay Load Qty arrived by any trucks in previous 1 hour period from time that one truck(the row in which new field value is being calculated) arrived by each OrderNo.
for example: when new field is being calculated for 3rd row, OrderNo is A and period in which sum of PayLoad Qty have to be take is 3rd row arrival time 11.5 to 10.5(11.5-1). so the 10.6,10.8, 11.5 itself is coming in Period so new field value would be 9+6+9=24.
I am expecting following table:
OrderNo,TruckNo,Arrival Time, Pay Load Qty, New Field
A, 1, 10.3, 7.6, 7.6 (=7.6)
A, 2, 10.6, 9, 16.6 (=7.6+9)
A, 3, 10.8, 6, 22.6 (=6+9+7.6)
A, 4, 11.5, 9, 24 (=9+6+9)
A, 5, 13.0, 8.5,8.5 (=8.5)
B, 1, 10.3, 8.4,8.4 (=8.4)
B, 2, 10.7, 6,14.4 (=6+8.4)
B, 3, 11.5, 9,15 (=9+6)
B, 4, 13.0, 8.5,8.5 (=8.5)
B, 5, 13.5, 8 ,16.5 (=8+8.5)
NOTE: Plz give Solution on Frontend (in Chart Expressions)
Thanks
Dinesh Yadav
#SetExpression #QlikChartExpression #AboveRowSum #RangeSum #windowSum #ArrivalTime #PayloadQty #Truck #QlikView #QlikSense #frontend
