Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
IRR and XIRR functions are avaliable in qlikview! how to use IRR and XIRR function in qlikview?
Regards,
3611
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.
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