topic filling in spaces and cumulative calculation in App Development

filling in spaces and cumulative calculation

AlejandroJuarez — Wed, 13 Dec 2023 04:14:05 GMT

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

Re: filling in spaces and cumulative calculation

hic — Wed, 20 Dec 2023 11:22:36 GMT

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.