Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Specialist III
Partner - Specialist III

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

vgutkovsky
Master II
Master II

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