Sum based on previous data

[Kwame]

Hi, 

I want to sum using previous data. That is adding the previous Daily interest to the Interest  for each current day.

So, 112.83 + 0.79 = 113.62 

Any ideas guys please?

Sample

Transaction Date	Transaction ID	Interest	Daily Interest
28/03/2022	1115700004	112.83	0.79

Desired Result

Transaction Date	Transaction ID	Interest	Daily Interest
29/03/2022	1115700004	113.62	0.72

[dmac1971]

Yes you should be able to do this at load using the Peek function :

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe... 

[MarcoWedel · Accepted solution]

one solution might be:

table1:
LOAD TransactionDate,
     TransactionID,
     DailyInterest,
     RangeSum(Peek(Interest),Previous(DailyInterest)) as Interest
Inline [
TransactionDate,TransactionID,DailyInterest 
27/03/2022,1115700004,112.83
28/03/2022,1115700004,0.79
29/03/2022,1115700004,0.72
30/03/2022,1115700004,0.71
31/03/2022,1115700004,0.75
01/04/2022,1115700004
];	

hope this helps

Marco

[Kwame]

Hi @MarcoWedel  

Just out of curiosity, how would this script "RangeSum(Peek(Interest),Previous(DailyInterest))" be translated into an expression in a chart type, Many thanks.

[dmac1971]

@MarcoWedel  look at https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In... it should help.