Hi All, I am experiencing some weird behavior with the XIRR function and it seems to be related to the input ordering that the function is applying. I have the attached scheduled payme...
Hello everyone, Is it possible to calculate the XIRR for the each of the below loans in Qlik ? For example: what is the XIRR for Loan1 having princiapl value of 3500 and repaid in 4 instalment 1000...
Hi All, I am experiencing a strange behavior with the XIRR formula. I have a very simple date set Load * inline [ Date,Amount,ID 2/3/2020,-57463519.21,ID 3/6/2020,-330276.80,ID 4/2/2020,-...
Hi All,
I have the below data and want to calculate XIRR. (note I have attached QVF which gives all this data)
My rule for calculating XIRR is as below
take amount from begining to s...
Hi All,
I have the below raw data and need to calculate XIRR
Requirement - Calculate XIRR of the script based on the date selection. Challenges - Bringing Opening and Closing values to the...
Hi All, I have created a expression for calculating XIRR on the basis of date selections in the qliksense KPI,i used below expressions =xirr(Sum({<Account={13405},[Date]={">=$(=Min({1} [Date]...
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 sho...
Hi Folks,
Does anyone know what methodology Qlik Sense uses to solve XIRR or IRR? Newton's method?
If possible, initially looking for a brief description - ideally simila...
Hi All, I have a requirement to calculate XIRR on date range as select by user. In short, In our requirement Opening and Closing is changing as per user selection for XIRR Calculation...
Hi All, Has anyone had a successful XIRR implementation in QlikView or QlikSense where you have other Fact Types integrated as well? I would be curious to see your example. I have very simp...
