Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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