topic Re: Tricky calculation using previous rows of a table in QlikView

Tricky calculation using previous rows of a table

Anonymous — Tue, 18 Dec 2012 15:50:22 GMT

ID	ID2	SumParts	Percent	Nr of Parts for every ID_ID2
12345	1	100	20	Round(100*0,2)
12345	2	100	30	Round(100*0,3)
12345	3	100	50	100-(Round(1000,2) +Round(1000,3))
54321	1	200	25	Round(200*0,25)
54321	2	200	75	100-(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

Re: Tricky calculation using previous rows of a table

fosuzuki — Tue, 18 Dec 2012 16:59:43 GMT

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

Re: Tricky calculation using previous rows of a table

vgutkovsky — Tue, 18 Dec 2012 17:00:38 GMT

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