Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all Experts,
I am new to qlikview and I am trying to figure out solution to - How to calculate XIRR of a dynamic table.
The table gets updated by other parameters. so with updated table i have date and payments. I want to calculate XIRR using this date and payments column.
for reading a table i am using this code in vb script -
set table = ActiveDocument.GetSheetObject( "CH0001" )
w = table.GetColumnCount
h = table.GetRowCount
set CellMatrix = table.GetCells2(0,0,w,h)
for RowIter=0 to h-1
for ColIter=0 to 2
msgbox(CellMatrix(RowIter)(ColIter).Text)
next
next
many many thanks.
It looked the same like Re: need help to update macro code.
- Marcus
hello Marcus,
Can you help me further,
for xirr calculation i can use field name but here i have variable names,
so is it possible I can change variable names to field names somehow?
my motive is to calculate xirr which allows parameters as field names not variable name.
thaks a lot for ur reply.
For me it's not clear why the table should be transferred per macro into variables and then back again evaluated instead of taking these table itself to perform your calculations?
- Marcus
how would u read a dynamic table without macro and the stored result will be in variable only, rit?
dats y im going by this approach. can u suggest me any other approach?
What do you mean with a "dynamic table". In general everything in qlikview is dynamic calculated on the fly depending on the made selections - and with the very powerful features of set analysis and/or aggr-functions you could very flexible trim the calculation like you want. Whereby quite often is it more suitable to precalculate some parts within the script-level to be able to use rather simply objects and expressions.
Therefore I suggest you create a small dummy-app with only a few very simple inline-data to get rid of the needed logic and syntax (without any macros).
- Marcus