topic Re: can we have cell value in QlikView

can we have cell value

Thu, 06 Jan 2011 14:21:45 GMT

HI can we get any cell value from a straight table to variable in qlikview ?

can we have cell value

suniljain — Thu, 06 Jan 2011 14:31:40 GMT

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

can we have cell value

brindlogcool — Mon, 16 Apr 2012 14:38:49 GMT

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.

Re: can we have cell value

murozel76 — Thu, 27 Sep 2012 11:11:55 GMT

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,