Calculation of future maturities for each day

[#1]

I need to calculate which is the total amount of daily deadlines for all future securities without defeat. The time limit in days.

For example:

Title     Start Date     Term     Amount

ABC     2012-06-07    5          $1000

AHK     2012-06-07    7          $1500

AVV     2012-06-07    1          $800

AMZ     2012-06-13    3          $700

Then QlikView should calculate the totals in securities futures every day, as follows:

Date              Amount

2012-06-07     $3300

2012-06-08     $2500  (ending on title AVV)

2012-06-09     $2500

2012-06-10     $2500

2012-06-11     $1500     (ending on title ABC)

2012-06-12     $1500

2012-06-13     $700         (AHK title ended but started the title AMZ)

2012-06-14     $700

2012-06-15     $700          (ending all titles)

Note that in the data, Qlikview does not have all the dates, and amountsare the future.

[rwunderlich · Accepted solution]

Try this:

Expanded:

LOAD

          Title,

          Date (StartDate + IterNo()-1) as Date,

          Amount

RESIDENT data

While IterNo() <= Term

;

-Rob

http://robwunderlich.com