topic Re: Function to get Object ID? in QlikView

Function to get Object ID?

gandalfgray — Tue, 23 Aug 2011 12:44:16 GMT

Is there a function to get the Object ID of the currently active object?

Function to get Object ID?

kaushiknsolanki — Tue, 23 Aug 2011 12:55:45 GMT

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

Regards,

Kaushik Solanki

Re: Function to get Object ID?

SunilChauhan — Tue, 23 Aug 2011 13:02:14 GMT

please see the attached file

Re: Function to get Object ID?

gandalfgray — Tue, 23 Aug 2011 15:09:16 GMT

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.

Re: Function to get Object ID?

tanelry — Wed, 24 Aug 2011 08:47:58 GMT

You can use Sheet Properties > Triggers > Sheet Object Event Triggers (OnActivate, OnDeactivate) to set variables.

Then use those variables in Show Condition.