Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simon20
Partner - Contributor III
Partner - Contributor III

Create dates in a range for future cash-flows

Hi,

I have uploaded an Excel with asset values, calculated based on a start date, an end-date, a payment frequency, a payment and a discount rate. (Basically NPV calculated over time).

Now I want to model the future cash-flow and asset depreciation starting from the start date for all contracts. I have seen some solutions, but they all assume that the data fields are all in the same table. In my case I have the values divided over 3 tables:

Table 1:
Frequency

Table 2: 
Unit price

Table 3:
Start Date
End Date
Discount rate

Table 1 and Table 3 are connected through Table 2. 

Labels (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

You'll have to create a table that contains all the fields needed to calculate the result values you want. 


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You'll have to create a table that contains all the fields needed to calculate the result values you want. 


talk is cheap, supply exceeds demand
simon20
Partner - Contributor III
Partner - Contributor III
Author

Ok, so the answer is in the import script then? In that I need to create one table with all the information needed to create the future cash flow?

Gysbert_Wassenaar

Yes, that's correct.

talk is cheap, supply exceeds demand