Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select all rows from a field in a straight table

Hi everybody,

this subroutine gives me back all rows in a straight table ("CH02")

All I need is to select in the field "MyField" the values I obtained from the straight table.
Or in other words, to select in the field MyField all "myvalues" values

Any suggestion ?

Thank you in advance

russianblue

This is the script:

Sub Selection_bingo
set f = ActiveDocument.Fields("MyField")
set table = ActiveDocument.GetSheetObject("CH02")
for RowIter = 1 to table.GetRowCount-1
for ColIter =0 to table.GetColumnCount-1
set myvalues= table.GetCell(RowIter,ColIter)
msgbox(myvalues.Text)
' f.select myvalues ?????????

next
next
End Sub

2 Replies
Not applicable
Author

store the value into a variable.

set v1='myfield'

call this value.

Not applicable
Author

Thank you Sunil,

but how can I then select all the values in the straight table "CH02" ?

rb