Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vmoreno2605
Contributor

Cumulative Sum in Script Qlik Sense

Hi Qlik Masters! 

I need your help!

Here is the situation: 

Here, i have this data

StoreCustomerReceipt_DateMoney in suspense
1104258950
11042895-50
1104300523
1104303569
1114150065
11141550-95
1114155558
11141623-450
11141950321
2124358965
21243599-65
2124360068
2124361265
21243615-265
2124365075
21342950-95
213429905
2134300032
21343101-12
213431255

 

And i want to create this column 'Cumulative'

StoreCustomerReceipt_DateMoney in suspenseCumulative
110425895050
11042895-500
110430052323
110430356992
111415006565
11141550-95-30
111415555828
11141623-450-422
11141950321-101
212435896565
21243599-650
212436006868
2124361265133
21243615-265-132
2124365075-57
21342950-95-95
213429905-90
2134300032-58
21343101-12-70
213431255-65

 

Any ideas? 

 

Thanks in advance

-D

Labels (3)
1 Solution

Accepted Solutions
Ezir
Contributor II

Re: Cumulative Sum in Script Qlik Sense

Hi @vmoreno2605 ,

In load editor you can use RangeSum() and Peek(). 

 

 

TABLE:
LOAD Store, Customer, Receipt_Date, [Money in suspense], RangeSum(peek('Cumulative') , [Money in suspense]) AS Cumulative ...

 

Regards,

 

Ezir

1 Reply
Ezir
Contributor II

Re: Cumulative Sum in Script Qlik Sense

Hi @vmoreno2605 ,

In load editor you can use RangeSum() and Peek(). 

 

 

TABLE:
LOAD Store, Customer, Receipt_Date, [Money in suspense], RangeSum(peek('Cumulative') , [Money in suspense]) AS Cumulative ...

 

Regards,

 

Ezir