Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

avastani
Contributor II

XIRR function mismatch

Hi,

Does anyone have experience with XIRR () function results not matching Excel or any other tool's XIRR() function result.

I Have a simple app here where my result is off by a few %.

I should be getting similar results but excel gives different XIRR

Of course for excel I have to have unique dates but that's the only difference whereby I summarize at date level

Tags (2)
Community Browser