Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

XIRR issue

 

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

 

2 Replies
swuehl
MVP
MVP

Maybe like this?

Anonymous
Not applicable
Author

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