calculate irr in table box - Page 3 - Qlik Community

Report Inappropriate Content · ‎2016-07-20

hi all,

i am able to read my table using macro -

Sub ReadStraightTable

Set Table = ActiveDocument.GetSheetObject( "CH05" )

For RowIter = 1 to table.GetRowCount-1

For ColIter = 2 to table.GetColumnCount-1

set cell = table.GetCell(RowIter,ColIter)

MsgBox(cell.Text)

End Sub

now i want to calculate irr in table box but im not getting how to pass table values from macro above to the table box properties to calculate irr. any help would be thankful.

Report Inappropriate Content · ‎2016-07-20

yup one column is dates and another one is amount

Clever_Anjos · ‎2016-07-20

you want to calculate iir using dates?

Report Inappropriate Content · ‎2016-07-20

plz have a look at my data. so i want to calc. for date and amount column.

Report Inappropriate Content · ‎2016-07-20

for calculating IRR we need to have dates and amount. so first column is dates only.

Clever_Anjos · ‎2016-07-21

As long as I know (IRR documentation : IRR - chart function ‒ QlikView) does not support dates.

"These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. "

Report Inappropriate Content · ‎2016-07-21

ok for xirr calculation we do need dates. i am trying to calculate either irr or xirr.

the table i have is in straight table. my question is to write a macro to that will read a table and then pass it to a variable and that varaible can be used in text for calc. of xirr as =xirr(var1,var2)