Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Dinesh_123
Partner - Contributor II
Partner - Contributor II

Need to get Sum of Payload Qty( delivered in past 1 hour) for every Truck and order.

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 

Labels (1)
0 Replies