topic How can I get ObjectID? in QlikView

How can I get ObjectID?

Wed, 14 Apr 2010 12:06:58 GMT

Hi,

I want manage objects on sheet (detach/clone/remove). But I don't know how to get ObjectID of active object.

I can save ObjectID for existing objects (I save it with trigger onActivate). But if I clone object, I will not know ObjectID of new object.

Can somebody help me?

Thank you beforehand

How can I get ObjectID?

sparur — Wed, 14 Apr 2010 12:29:23 GMT

Hi, Irina, ObjectID assigned in order for each object. if there is an object CH10, then your new (cloned) object will CH11

How can I get ObjectID?

Wed, 14 Apr 2010 12:47:11 GMT

It's true only if cloned object was last object. If there is no object CH11.

In case I have objects CH10, CH11, CH12 then I clone CH10, new object will CH13. But I can't know what ObjectID in a sheet last

How can I get ObjectID?

sparur — Wed, 14 Apr 2010 13:35:32 GMT

Irina I can't find function which can calculate Max Object ID, but I created small example, I hope it can help you. 🙂

How can I get ObjectID?

Wed, 14 Apr 2010 13:56:00 GMT

Your example is very useful, but not in my case... I need clone different charts. Even if I would create new objects with your method, I must know properties of active object, what I clone...

Any way thank you, Anatoly.

How can I get ObjectID?

sparur — Wed, 14 Apr 2010 13:58:16 GMT

Or you can use GetSheetObjects function and calculate this value:

Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For i = lBound(Objects) To uBound(Objects)
If Objects(i).GetObjectType = 10 Then 'pivot tables
set Pivot = Objects(i)
msgbox(Pivot.GetObjectId)

end if
next

How can I get ObjectID?

sparur — Wed, 14 Apr 2010 14:00:14 GMT

Can you post your qvw example ? I can't understand what you need.

How can I get ObjectID?

Wed, 14 Apr 2010 14:36:18 GMT

I attach my example. I can clone active old objects and detach/attach it. But I can't remove new cloned objects because I don't know it's IDs

How can I get ObjectID?

sparur — Wed, 14 Apr 2010 20:10:10 GMT

see in attached file.

the first chart in cycle - is your new object. "Pivot" it's your new sheet object. and you can manage it.

How can I get ObjectID?

Fri, 23 Apr 2010 09:01:36 GMT

select object_id('schemaname.objectname') as 'Object Id'

Default schema is dbo

Object Name may be table name,trigger name,view name etc..

Best of Luck