Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
juleshartley
Valued Contributor

IRR function does not match Excel


Hi,

I am trying to do a simple IRR function that you feed some monthly cashflows in date order. I am comparing this to Excel and the results are quite different.

The function that I'm using is :

pow

((1+IRR(IRR.Cashflow)),12)-1

in Qlik and

= (1+IRR(D2:D481, 0))^(12)-1

In Excel.

Can anyone advise why I might be getting different answers? FYI, it seems that Excel is CORRECT!

Thanks.

Tags (1)
1 Solution

Accepted Solutions
juleshartley
Valued Contributor

Re: IRR function does not match Excel

Turns out that the cashflows needed to be loaded into the app in the correct order (rather than just sorted once in)... values seem to match now! Thanks everyone.

View solution in original post

2 Replies
Not applicable

Re: IRR function does not match Excel

I am not getting different results between excel and qlikview, could it be a rounding error?

Only time I've had issue cropping up with IRR has been when the first value hasn't been a negative

juleshartley
Valued Contributor

Re: IRR function does not match Excel

Turns out that the cashflows needed to be loaded into the app in the correct order (rather than just sorted once in)... values seem to match now! Thanks everyone.

View solution in original post