topic Re: Active object? in QlikView

Active object?

Thu, 14 Mar 2013 13:48:24 GMT

HI Guys,

Any body knows the function to get the active object in a sheet?

Thanks,

shree909 — Thu, 14 Mar 2013 13:51:52 GMT

Hi when u use the either textbox or button and wen you goto the actions ===>>Layout

u will find the activate object ..

U can use that option to activate when u kick of the button..

Thanks

sree

Gysbert_Wassenaar — Thu, 14 Mar 2013 13:53:46 GMT

There is no function for that. You can only find that out with a macro

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

for i=lbound(objs) to ubound(objs)

if objs(i).IsActive then msgbox objs(i).getobjectid

Thu, 14 Mar 2013 13:57:06 GMT

Thanks for reply.

I want to get the objet id and use it in a function , so I need to get the object id each time I click on an object....

Thu, 14 Mar 2013 14:05:14 GMT

Can I call this macro in an expression?

Thanks,

Gysbert_Wassenaar — Thu, 14 Mar 2013 14:06:18 GMT

Thu, 14 Mar 2013 14:26:46 GMT

Hi,

Please Find The Attachment Try this hope this is helpful for you

Regards,

Nirmal.