Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Sum-SubTotals-2011021900.qvw]
Hi guys,
Need help to solve the following situation:
Please see the qvw attached.
I have a table with a list of actions (ACTs) to be done to a specific work order (Serial Key).
The expression "Line Time" gives me the number of minutes I have to work on EACH step (ACT).
In the expression "Line Time Sub Total" I need to calculate the number of minutes of ALL the acts that their position "Pos" value is smaller or equal to the position of the current act, so:
Act, Pos, LineTime, LineTimeSubTotal
100, 10, 1, 1
80, 20, 2, 3
500, 30, 1, 4
and so on...
I have to solve it in the script.
Thanks in advance,
Aldo.
I solved it using RangeSum()... see below.
Aldo.
Chart2_16:
LOAD
'A'
,[Serial Key]
,[Act]
,[Pos]
,[Act Name]
,[Act Des]
,[Total WTime]
,[Total EmpTime]
,[Total LineTime]
,RangeSum(Peek(LineTimeSubTotal),[Total LineTime]) as LineTimeSubTotal
RESIDENT Chart2_17
ORDER BY [Serial Key], Pos;
DROP TABLE Chart2_17;
I solved it using RangeSum()... see below.
Aldo.
Chart2_16:
LOAD
'A'
,[Serial Key]
,[Act]
,[Pos]
,[Act Name]
,[Act Des]
,[Total WTime]
,[Total EmpTime]
,[Total LineTime]
,RangeSum(Peek(LineTimeSubTotal),[Total LineTime]) as LineTimeSubTotal
RESIDENT Chart2_17
ORDER BY [Serial Key], Pos;
DROP TABLE Chart2_17;