add up daily values in a column and get cumulative sum column

[Anonymous]

Hi Team,

I have a table like this with only daily number. I want  insert a 'cum' column which has daily values added up till date.

When I load while loading file I am getting 'above' is invalid error.

Date	dailyno	Cum
07-01-2017	10	10
07-02-2017	20	30
07-03-2017	40	70
07-04-2017	30	100
07-05-2017	20	120
07-06-2017	30	150
07-07-2017	20	170
07-08-2017	10	180
07-09-2017	40	220
07-10-2017	20	240

rangesum(above(dailyno),0,rowno())) did not work for me.

Here is how I tried this.

LOAD

date,

dailyno

FROM [lib://main (qlik_admin)/dailydata.qvd]

(qvd);

I have loaded extra coloumn, it did not work

LOAD

date,

dailyno,

rangesum(above(dailyno),0,rowno()))

FROM [lib://main (qlik_admin)/dailydata.qvd]

(qvd);

The help is appreciated. Thank you.

[Anonymous]

Hey Chanin, The above function won't be accepted in the data load. It is accepted only in the expression. But thanks for your reply. I appreciate the help.

[Anonymous]

Thanks for all the replies guys and I marked the correct answer.

Please you can not use 'Above' in the load script as it will throw an error. 'Peak' works well. Thanks.