topic Re: if, peek and rangesum in script in QlikView

if, peek and rangesum in script

jduluc12 — Thu, 11 Feb 2021 09:32:00 GMT

Hi,

I have data like this.

Item	Incr	Decr
A	1	0
A	2	1
A	3	1
B	4	0
B	2	1
B	5	3

I want to a running total for each item and the output should look like this

Item	Incr	Decr	RunningTotal
A	1	0	1
A	2	1	(1+2) - 1 = 2
A	3	1	(2+3) - 1 = 4
B	4	0	4
B	2	1	(4+2)-1 = 5
B	5	3	(5+5) - 3 = 7

ItemRunningTotal:
Load Item, incr, decr

if (peek(Item) = Item, rangesum(peek(RunningTotal), Incr, -Decr)) as RunningTotal

Resident Item;

Is it correct?

Thanks

Re: if, peek and rangesum in script

Frank_Hartmann — Thu, 11 Feb 2021 16:55:59 GMT

Try like this:

tmp: LOAD Item, Incr, Decr FROM [https://community.qlik.com/t5/QlikView-App-Dev/if-peek-and-rangesum-in-script/td-p/1781908] (html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1); NoConcatenate Final: LOAD *, If(Item=Previous(Item), RangeSum(Peek('RUNNING_TOTAL'), Incr-Decr), Incr-Decr) as RUNNING_TOTAL Resident tmp Order By Item, Decr; DROP table tmp;