topic Re: Applying above with more than one row in script in QlikView

Applying above with more than one row in script

Anonymous — Fri, 17 Jul 2015 09:21:29 GMT

Hi,

as we know, the above function does not work at scriptlevel.

So, im looking for something like that at scriptlevel:

rangesum(above(Value,0,rowno()+11))

Sure, there are the previous or peek functions, but to my knowledge these wont take a range of rows like 'above' for whatever reason....

Re: Applying above with more than one row in script

MK_QSL — Fri, 17 Jul 2015 09:24:59 GMT

You have to create some flag to count number and use them with if condition.

But better to have a look into below blog post...

Calculating rolling n-period totals, averages or other aggregations

Re: Applying above with more than one row in script

Anonymous — Fri, 17 Jul 2015 11:27:36 GMT

Hi Manish,

thx for your quick reply.

It works for me like so:

rangesum(Value, peek(Value, -1),peek(Value, -2),peek(Value, -3),.......) as Rolling12MontsValue

Not really elegant but its easy to implement and works.

Re: Applying above with more than one row in script

MK_QSL — Fri, 17 Jul 2015 11:55:51 GMT

Great that you got expression. Try to implement the same using the link provide above in my first reply. If you want RollingValues, this is the best approach.