topic Objects IDs from Sheet in macro in QlikView

Objects IDs from Sheet in macro

Wed, 14 May 2014 08:31:51 GMT

Hello everyone,

is there any way how I can get a list of all the object Ids from a single sheet using a macro?

regards,

Re: Objects IDs from Sheet in macro

ashfaq_haseeb — Wed, 14 May 2014 08:37:25 GMT

Hi you can use below

ActiveDocument.GetSheetObject("CH01")

Regards

ASHFAQ

Re: Objects IDs from Sheet in macro

tresB — Wed, 14 May 2014 08:43:00 GMT

try like:

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

ID(objects)

For i = lBound(Objects) To uBound(Objects)

ID(i) =Objects(i).GetObjectID

Re: Objects IDs from Sheet in macro

Wed, 14 May 2014 08:44:14 GMT

but my question was how i can figure out the object ID?? just to be a little more specific. for example i have a sheet called April and now on this sheet there are 3 pivot charts. how can I get a list of the object ID from these 3 pivot charts.

regards,

Re: Objects IDs from Sheet in macro

luciancotea — Wed, 14 May 2014 08:50:17 GMT

You can use QV Plus - Expression Manager to list all the objects by sheet (Type, ID and Caption)

Re: Objects IDs from Sheet in macro

marcus_sommer — Wed, 14 May 2014 11:05:15 GMT

Have a look in APIGuide.qvw. There you will find examples like them from tresesco suggested which is already the right approach for you - loop through each sheet for each object and return the type, id and so on and if it match your condition do something.

Alternatively you could read these kind (and some more) of meta-data from document layout (file --> export --> document layout).

- Marcus