filling in spaces and cumulative calculation

[AlejandroJuarez]

hi

I hope you can help me, I need to create a customer index based on the increases
where the index is never zero, but I copy the last value, if it has not increased, if it has increased I need to calculate the index by the increase

[hic]

If you want to do the accumulation in the script and the data is ordered by client and date, you can try

Load 

If(Client=Peek(Client),RangeSum(Peek(Index),Increase), 100) as Index,

*

From Data;

If you want to do the accumulation in a chart, you can try method 2 on https://community.qlik.com/t5/Design/Accumulations/ba-p/1466581.