topic Re: Add object to a container in QlikView

Add object to a container

Tue, 23 Oct 2012 13:53:32 GMT

Hi,

I'm trying to add an object to a container using a simple MACRO, but it is not working and no error is triggered. I think that it is braking on "objectId" line.
Any ideas?

OPTION EXPLICIT

SUB test

DIM customFilter

DIM customFilterProperties

DIM containedObjects

SET customFilter = ActiveDocument.GetSheetObject("Document\CT01")

SET customFilterProperties = customFilter.GetProperties

SET containedObjects = customFilterProperties.ContainedObjects

'Lenght

containedObjects.Add

containedObjects.Item(0).ObjectId="Document\TX01"

containedObjects.Item(0).Text.v="Lenght"

customFilter.SetProperties customFilterProperties

END SUB

Example document is attached.

Thanks

Re: Add object to a container

Gysbert_Wassenaar — Tue, 23 Oct 2012 14:05:20 GMT

See attached qvw

Re: Add object to a container

Tue, 23 Oct 2012 14:09:22 GMT

Hi Gysbert,

Thanks for your reply. Sorry, I didn't specified that I am using QV 11, so the line below dosen't work. "Id" is obsolete according to the API (that's why I used objectId instead)

lineContProp.ContainedObjects.Item(0).Id = "Document\TX01"

Re: Add object to a container

Tue, 23 Oct 2012 14:25:56 GMT

Found the solution

SUB test

Set ContainerObj =ActiveDocument.GetSheetObject( "CT06" )

set ContProp=ContainerObj.GetProperties

ContProp.ContainedObjects.Add

ContProp.ContainedObjects.Item(0).Def.ObjectId = "Document\TX01"

ContProp.ContainedObjects.Item(0).Text.v = "Hello"

ContainerObj.SetProperties ContProp

END SUB