xIRR Function Problem

juleshartley — Wed, 28 Mar 2012 13:53:39 GMT

The issue is quite simple – if you have exactly the same value on the same date and the dimension that separates them is not part of the table then xIRR groups them, like a list box, and so misses some values.

For example if you have these cashflows:

Investor A	01/01/2001	1000
Investor B	01/01/2001	1000
Investor A	01/03/2001	2000
Investor A	01/06/2001	2500
Investor B	01/09/2001	500

And calculated IRR at a level that didn't include Investor, QlikView would ignore one of the first 2 cashflows.

Does this make sense and can anyone think of a way around it? I’ve tried putting sums etc. within the IRR function but it doesn’t likethat. Horrible way around would be to create aggregations in the load… but that causes big headaches.

topic xIRR Function Problem in QlikView

xIRR Function Problem