Discussion Board for collaboration related to QlikView App Development.
Is there a function to get the Object ID of the currently active object?
Hi,
Try this Code.
set s=ActiveDocument.ActiveSheet
for i=0 to s.NoOfSheetObjects-1
if s.SheetObjects(i).IsActive then
id = s.SheetObjects(i).GetObjectId
msgbox("ID = " & id)
End if
next
Regards,
Kaushik Solanki
please see the attached file
Thanks for your suggestions, but it's not possible (as far as I know) to use macro code in for instance the Show Condition statement for an object (a Chart, a Listbox etc), and thats where I would like to use such a function, to be able to write a generic Show Condition statement.
You can use Sheet Properties > Triggers > Sheet Object Event Triggers (OnActivate, OnDeactivate) to set variables.
Then use those variables in Show Condition.