Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
melghandour89
Partner
Partner

for loop in table to create another table

Hi all,

I need help in creating asset's future depreciation

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

Assets No.YearMonthAmountDepValueDep-End-Date
2871951509189015.7509/30/2025
28719516115004.1709/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.YearMonthAmountDepValue
287195201510189015.75
287195201511189015.75
..........
2871952016115004.17
..........
2871952025095004.17

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

1 Reply
MarcoWedel

maybe helpful:

Generating Missing Data In QlikView

regards

Marco