topic XIRR issue in QlikView

XIRR issue

Anonymous — Wed, 21 Dec 2016 04:12:17 GMT

Hi All,

I need help with this XIRR Calculation. Currently it’s showing 0% but when I use the XIRR function in Excel I got -5.2788%.

Thanks,

Frankie

Re: XIRR issue

swuehl — Wed, 21 Dec 2016 09:45:05 GMT

Maybe like this?

Re: XIRR issue

Anonymous — Wed, 21 Dec 2016 15:29:35 GMT

Hi Stefan,

Thanks for looking into this. It works when I apply it to just one Name/Security. But when I try to add multiple Name/Security, it didn't work. Let me know if you can assist. Attached QVW. Object (B) is what I wanted to accomplish, currently there are blank XIRR for Name, AAA,CCC,EEE,GGG,AND III.

Many Thanks!

Frankie