Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the selected column in a table

Hi,

I'm trying to do a macro that triggers when a selection is made and check at what column of the table are you cliking at.

I already got the code to loop throught the fields but I cannot know if the exprecsion colum are selected or not.

That's the macro:

sub testTable


     set objCust = ActiveDocument.Fields("Sub Region")
     set table = ActiveDocument.getsheetobject("CH16").getrelevantselections


     for rowIter = 1 to table.GetRowCount-1
          set cell = table.GetCell(rowIter,1)

          msgBox(cell.text)

          set cell = table.GetCell(rowIter,2)
     next
end sub


I attach the file too.

0 Replies