Creating a Table similar to Attached excel file

[alkesh_sharma]

Hello All,

I want to create a table as the table in the excel file attached.

Year 1.....Year 2 represents the assets years they are in service. I want to start with the first Year when are placed in service and till its useful life completes.

Year1 Residual Value, Net Book Value and useful life are given to me, rest all needs to be calculated.

There are formulates in excel for reference.

I need to create replica in qlikview.

[rubenmarin · Accepted solution]

Check attachment, if you select an asset the table will show the values

[rubenmarin]

I already see, I think it doesn't gives the expected result for the 9,5 lifetime asset, or is it ok?

[alkesh_sharma]

Hey Ruben,

It's Not working for any asset.. or guess I am doing it wrong.

Here is the attached snapshot.

I do selected the asset category but there is no value displayed in the table above..

[alkesh_sharma]

I figured it out, Its working... Thanx for the help.

But I do need to create depreciation tables for different depreciation Methods..

I might require your help soon for them as well.....

Cheers and Thanx a ton!