Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chesterluck
Contributor II

Tricky calculation using previous rows of a table

IDID2SumPartsPercentNr of Parts for every ID_ID2
12345110020Round(100*0,2)
12345210030Round(100*0,3)
12345310050100-(Round(100*0,2) +Round(100*0,3))
54321120025Round(200*0,25)
54321220075100-(Round(200*0,25))

Hello everybody,

go you know to accomplish such a task?

I have a table which incl everything but not the last column (Nr of Parts for every ID_ID2). The only problem is the max(ID2) for every ID - here I need to calculate with the nr of the lower ID2 Keys...

Any ideas??

cheers chesterluck

2 Replies
fosuzuki
Valued Contributor II

Re: Tricky calculation using previous rows of a table

Do u want do do it via script or interface (table object)?

vgutkovsky
Honored Contributor II

Re: Tricky calculation using previous rows of a table

I don't understand your formula--can you elaborate on the progression?

Community Browser