topic Re: Question about Accumulate data with script in QlikView

Question about Accumulate data with script

Mon, 16 Jan 2017 03:08:36 GMT

I have data something like columns below

Date	Machine No.	TR-RPM
01/01/2017	MA001	7436
02/01/2017	MA001	7436
03/01/2017	MA001	7436
04/01/2017	MA001	7436
05/01/2017	MA001	7436
01/01/2017	MA002	7524
02/01/2017	MA002	7524
03/01/2017	MA002	7524
04/01/2017	MA002	7524
05/01/2017	MA002	7524
01/01/2017	MA003	7656
02/01/2017	MA003	7656
03/01/2017	MA003	7656
04/01/2017	MA003	7656
05/01/2017	MA003	7656

and the result that I need as column result.

Date	Machine No.	TR-RPM	result
01/01/2017	MA001	7436	7436
02/01/2017	MA001	7436	14872
03/01/2017	MA001	7436	22308
04/01/2017	MA001	7436	29744
05/01/2017	MA001	7436	37180
01/01/2017	MA002	7524	44704
02/01/2017	MA002	7524	52228
03/01/2017	MA002	7524	59752
04/01/2017	MA002	7524	67276
05/01/2017	MA002	7524	74800
01/01/2017	MA003	7656	82456

So How to coding script for accumulate data with column TR-RPM ?

Thank you.

Re: Question about Accumulate data with script

amit_saini — Mon, 16 Jan 2017 05:21:02 GMT

Hello,

Use this as expression:

rangesum(above(total sum([TR-RPM]),0,Rowno(TOTAL)))

Thanks,

Re: Question about Accumulate data with script

marcus_sommer — Mon, 16 Jan 2017 09:42:35 GMT

The suggestion from Amit is for using within a chart in the gui which might already suitable for your needs. If you instead want to calculate it within the script you could use peek() for it, like this example:

...

rangesum([TR-RPM], peek('result')) as result

...

within a proper sorted resident-load. More could you find here: Peek() or Previous() ?‌

- Marcus

Re: Question about Accumulate data with script

ahaahaaha — Mon, 16 Jan 2017 13:25:56 GMT

Alternatively, you can use this expression

numsum( [TR-RPM], peek( 'result' ) ) as result

But correct to use rangesum() function as written above Marcus

Re: Question about Accumulate data with script

Tue, 17 Jan 2017 01:50:01 GMT

Thank you all for suggestion,

but I need to use rangesum() with column [TR-RPM] and the answer that I want same as column "result".

I try to use script as below.

rangesum([TR-RPM],peek([TR-RPM],-1)) as result

then the result that I got ,It's not correct.

How to make column "result" to show accumulate data from column TR-RPM?

Re: Question about Accumulate data with script

marcus_sommer — Tue, 17 Jan 2017 12:14:51 GMT

I think you missed the essential requirement for using peek/previous within the above answer:

" ... within a proper sorted resident-load."

- Marcus