How can i transform Above(TOTAL) into Script using peek / previous

[sked9111]

Hi everyone!

My question it's in the subject.

Basically the expression i'm using is this:  RangeSum(Above(TOTAL percentTest ,0 ,RowNo(TOTAL)))

So how can i bring that expression into script using peek/previous or any other alternatives?

[edwin]

there must be a reason you are doing this - is it performance?  if so this could mean you have a huge data set - peek would be very slow - you can use  a bridge table.  having an idea how our data is modeled would be great help.  maybe post some sample data or QVF with test data  

[sked9111]

Hi @edwin ,

I attached the data. 

So, i'm trying to make an accumulative column in script using this expression:

RangeSum(percentTest ,peek('AcummulativeSum')) as AcummulativeSum

but somehow qlik can't accumulate correctly like in front :

RangeSum(Above(TOTAL percentTest,0,RowNo(TOTAL))) //front - end

[sked9111 · Accepted solution]

I managed to solve here. So basically i needed to resident table with the column (table1) and over that table i could make the accumulative sum with order by.