aggr(rangesum(above(sum(value1),0,rowno()),quarteryear) in script ???

[stonecold111]

Hi Qlikss,

I have 3 fileds  : quarteryear   value1    value2

                               2018-Q1            10               50

                               2018-Q2            20              40                     ...... Etc.....

 i have calculated rangesum in char

t by using expression : aggr(rangesum(above(sum(value1),0,rowno()),quarteryear)

which worked fine, but i want to calculate that in script. someone suggest me.

Attached excel file and screenshot .

@sunny_talwar 

[stonecold111]

Anyone has solution?

[Vegar · Accepted solution]

Perioddata:
Load yearquarter, field1, field2
From Excel.xlsx;

NoConcatenate
Load
yearquarter,
field1,
field1 + peek('accField1') as accField1,
field2,
field2 + peek('accField2') as accField2
Resident
Perioddata /*important to get the data in correct order*/
Order by
yearquarter
;

Drop table Perioddata;

[stonecold111]

Thanks