How to use the IRR & XIRR functions in qlikview?

[#1]

Hi,

IRR and XIRR functions are avaliable in qlikview! how to use IRR and XIRR function in qlikview?

Regards,

3611

[maksim_senin]

Hi,

It seems the IRR/XIRR functions have some secret or does not work properly. Below is my script, the IRR atribute contains "-" as well as IRR(Payment) expression in all possible combinations with TOTAL in chart display the same too.

[

Pay:

LOAD * Inline

[Year, Date, Payment

2012, 01.01.2012, 100

2012, 02.01.2012, -100

2012, 01.02.2012, 200

2012, 02.02.2012, -100

2012, 01.03.2012, 150

2012, 02.03.2012, -100

2012, 01.04.2012, 100

2012, 02.04.2012, -50

2012, 01.05.2012, 120

2012, 02.05.2012, -10

2012, 01.06.2012, 200

2012, 02.06.2012, -200

2012, 01.07.2012, 130

2012, 02.07.2012, -30

2012, 01.08.2012, 90

2012, 02.08.2012, -130

2012, 01.09.2012, 30

2012, 02.09.2012, -50

2012, 01.10.2012, 150

2012, 02.10.2012, -50

2012, 01.11.2012, 200

2012, 02.11.2012, -150

2012, 01.12.2012, 200

2012, 02.12.2012, -100

];

IRR:

LOAD

          Year,

          IRR(Payment) as IRR

Resident Pay

Group By Year;

]

What is the problem?

We use QV 11 SR2.

[maksim_senin]

It seems I found a mistake

IRR does only works when each income follows payment, at least the very first value should be a paymeny, i.e. should be negative.

Here are my observations:

1. IRR works (= 0.2)

2012, 01.01.2012, -100

2012, 02.01.2012, 120

2012, 01.02.2012, -100

2012, 02.02.2012, 120

OR

2012, 01.01.2012, -100

2012, 02.01.2012, 120

2012, 01.02.2012, 100

2012, 02.02.2012, -120

2. IRR does not work:

2012, 01.01.2012, 120

2012, 02.01.2012, -100

2012, 01.02.2012, 100

2012, 02.02.2012, 120

Best regards,

Maxim