How to consider sum( Xi+1 - Xi ), where Xi - each ... - Qlik Community

Report Inappropriate Content · ‎2010-09-20

Hi all,
Can anyone help, how to consider sum( Xi+1 - Xi ) in chart, where Xi - each record of the field?

Miguel_Angel_Baeyens · ‎2010-09-20

Hello,

You can do something like the following in your load script:

LOAD FieldID, Amount, If(Previous(FieldID) = FieldID, RangeSum(Amount, Previous(Amount))) AS Acum FROM FILE.QVD (QVD)GROUP BY FieldIDORDER BY FieldID DESC

Hope that helps

How to consider sum( Xi+1 - Xi ), where Xi - each record of thw field?