Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.