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

Get value of row/column in table object

I'm looking to grab / fetch a specific value of a row / column from a table object, for use in another object.

So lets say I have a table object with ID of OBJECT1.

In another object, say a text object, I want to say something like: =OBJECT1.Column(2) and simply display the number which exists in that column/row of object 1.

Any way to do this?

Dan

2 Replies
Not applicable
Author

Bump. Can anyone help?

tresesco
MVP
MVP

You can't directly refer an object row in qv like that. You should rather refer the data considering it's POV. Otherwise, there is macro, somthing like:

set obj = ActiveDocument.GetSheetObject( "BU01" )
CellRect = ActiveDocument.GetApplication().GetEmptyRect()
CellRect.Top = 0
CellRect.Left = 0
CellRect.Width = obj.GetColumnCount
CellRect.Height = obj.GetRowCount
set CellMatrix = obj.GetCells( CellRect )
for RowIter=CellRect.Top to CellRect.Height-1
    for ColIter=CellRect.Left to CellRect.Width-1
        msgbox(CellMatrix(RowIter)(ColIter).Text)
    next
next