Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI can we get any cell value from a straight table to variable in qlikview ?
set table = ActiveDocument.GetSheetObject( "CH01" )
for RowIter = 0 to table.GetRowCount-1
for ColIter =0 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)
msgbox(cell.Text)
next
next
Thanks Sunil,
The code is very useful . I want to get the maximum value of a specific column.If there are 10 rows in a straight or pivot table, then i would like to get the max value of 10 rows. Is it feasible.
Hello,
I have a very similar problem, but I can not make the code above work as it is i.e. "set cell = table.GetCell(Rowiter, Coliter)" can only work when written as "set cell = table.GetCell(Rowiter, Coliter).text". However, this time the variable takes it as "text" and can not be used for any mathematical operation. Any help on this appreciated, please.
Regards,