Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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