topic Re: RangeSum function in script in App Development

RangeSum function in script

ena1309 — Thu, 16 Jun 2022 11:11:39 GMT

Hi Qlikers,

I don't know why but i am always having troubles to create measure from front-end in data_load_editor script;
How to write this expression in script please in order to get the third column in prtscr:
RANGESUM(ABOVE(TOTAL SUM([_C_Free_Stock_Balance(Fixed)]),0,ROWNO(TOTAL)))

whatever i tried in script, i get different numbers..

Re: RangeSum function in script

marcus_sommer — Thu, 16 Jun 2022 13:54:38 GMT

It might be look like:

t: load A, B, C, if(A = previous(A), rangesum(C, peek('D')), C) as D
resident X order by A, B;

- Marcus

Re: RangeSum function in script

ena1309 — Sun, 19 Jun 2022 19:02:29 GMT

unfortunately something doesn't calculate right, because with that function I get different values than when I do it front in master item 😕

Re: RangeSum function in script

marcus_sommer — Tue, 21 Jun 2022 07:36:29 GMT

You need to adapt it to your used dimensionality - this means you may need to include more checks within the if-loop(s) as just A = previous(A) - and/or the sorting is different which is applied per order by statement.

You may just add a recno() and a rowno() within the load to see which source-record becomes now which target-record and with this information you could adjust the sorting.

- Marcus