topic Re: How can i transform Above(TOTAL) into Script using peek / previous in App Development

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

sked9111 — Thu, 07 Jul 2022 13:01:02 GMT

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?

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

edwin — Thu, 07 Jul 2022 14:12:25 GMT

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

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

sked9111 — Thu, 07 Jul 2022 14:43:22 GMT

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

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

sked9111 — Thu, 07 Jul 2022 20:36:10 GMT

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.