for loop in table to create another table

[melghandour89]

Hi all,

I need help in creating asset's future depreciation

I'v table named 'AssetsInfo' Which contain this rows

Assets No.	Year	Month	Amount	DepValue	Dep-End-Date
287195	15	09	1890	15.75	09/30/2025
287195	16	11	500	4.17	09/30/2025

I need to create depreciation table by using above table .

what I think to do for loop from first row (Year-Month) to second row (Year-Mont) then from second row to Dep-end-date with given amount

the achieve table that need to create as a below

Assets No.	Year	Month	Amount	DepValue
287195	2015	10	1890	15.75
287195	2015	11	1890	15.75
..	..	..	..	..
287195	2016	11	500	4.17
..	..	..	..	..
287195	2025	09	500	4.17

Can Any one help me You will find in the attached file the qvf

[MarcoWedel]

maybe helpful:

Generating Missing Data In QlikView

regards

Marco