0 Replies Latest reply: Mar 28, 2012 9:53 AM by Hartley Julian RSS

    xIRR Function Problem

    Hartley Julian

      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.