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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

 

Labels (1)
2 Replies
swuehl
Champion III
Champion III

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