topic Re: Loop through rows of a Straight Table (Chart) in QlikView

Loop through rows of a Straight Table (Chart)

Anonymous — Mon, 03 Jun 2013 15:21:24 GMT

I have successfully combined multiple tables into an inner joined straight table. I know how to loop through the rows of a single table. Is it possible to loop through the rows of a straight table using script?

Jerry

Re: Loop through rows of a Straight Table (Chart)

alexandros17 — Mon, 03 Jun 2013 15:24:41 GMT

For i = 1 to noofRows(table)

let myvalue = peek('field', $(i))

Re: Loop through rows of a Straight Table (Chart)

Anonymous — Mon, 03 Jun 2013 16:18:30 GMT

A straight table (chart) object is not a regular table. I have tried using the object name as the table name and using the caption, but neither version will return the number of rows.

Re: Loop through rows of a Straight Table (Chart)

rwunderlich — Tue, 04 Jun 2013 06:55:30 GMT

No, you cannot access a sheet object from script. You will need to create a qv table in the script that mimics the contents of the straight table object.

-Rob

Re: Loop through rows of a Straight Table (Chart)

Thu, 07 Nov 2013 12:17:25 GMT

Yes you can loop through the records from script:

sub ReadTable

set table = ActiveDocument.GetSheetObject( "CH218" ) ' Use Object ID

for RowIter = 1 to table.GetRowCount-1

for ColIter = 0 to table.GetColumnCount-1

set cell = table.GetCell(RowIter,ColIter)

msgbox(cell.Text)

end sub

Above works perfectly for me.

Its even possible to insert, and update records too.

Regards

Corrie