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]

Hi Alkesh, seeing the Excel it seems you also need the % of depreciation expense per year, I didn't see any logical evolution you can extract from the initial data given. Or how you obtain that value?

[alkesh_sharma]

Hey Ruben, That (100/1000) are the two fixed value that user would provide. or Take it as (var1/var2) where var 1 and var 2 will be provided by the user.

[#4]

Hi Alkesh,

1. Load the excel with the values provided to you.

2. Use a Straight table (Under Charts) , select Year as ur dimension.

3.Under expression add the fields you have and also add the calculations under the definition of the expressions and label them accordingly.

The calculations are very simple... you can directly write the mathematical expressions with the field names u have.

I hope it helps.

[rubenmarin]

Hi, Check attachment, in script i made the percentage provided by year.

[alkesh_sharma]

Hey Snehaleela,

If you look at the calculations carefully, its not as simple as creating it in a straight table.

The Net Book value of Year 2 is the Year end book value of Year 1.

This needs to be scripted in the back-end probably using previous or before function.

It would be highly appreciable if you can help.

[alkesh_sharma]

Hey Ruben,

Well this is not exactly what I needed but I guess I can tweak it to get the result.

Thanx a ton,

Alkesh

[alkesh_sharma]

Hey Rubin, a little more help

What would if I have the data in the attached format.

I need to create the table for every Asset category and I need to create the Year1 Year 2 etc from the capitalization and Useful life.

For: eg:  Capitalization Date = 1/1/2000 and useful life is 10 than year would be 10 years from 1 to 10 or if the use ful life is 15 than there would be 15 years from 1 to 15.

Please Help.

[rubenmarin]

Hi Alkesh, but there you don't know wich depreciation percentage applies to each year per asset, can you expect it will be equal aprt for every year? ie, for 10 year of useful life, it corresponds a 10% to each year?

[alkesh_sharma]

I guess we can do that, we can do 100% / no. of years