Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
testuser123
New Contributor

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. 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create dates in a range for future cash-flows

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
3 Replies
MVP & Luminary
MVP & Luminary

Re: Create dates in a range for future cash-flows

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
testuser123
New Contributor

Re: Create dates in a range for future cash-flows

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?

MVP & Luminary
MVP & Luminary

Re: Create dates in a range for future cash-flows

Yes, that's correct.

talk is cheap, supply exceeds demand