Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fanko1225
Creator
Creator

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?

fanko1225
Creator
Creator
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