topic Re: Add SheetObject (Straight-Table) to Container with Macro in QlikView

Add SheetObject (Straight-Table) to Container with Macro

Wed, 06 Jul 2016 08:10:44 GMT

Hello together,

I´m trying to add a straight-table Object to a Container-Object with a Macro. The API-Guide provides the following example for this:

Set ContainerObj = ActiveDocument.Sheets("Main").CreateContainer

set ContProp=ContainerObj.GetProperties

ContProp.ContainedObjects.Add

ContProp.SingleObjectMode=1

ContProp.SingleObjectStyle=1

ContProp.ShowObjectTypeIcons=true

ContProp.ContainedObjects.Add

ContProp.ContainedObjects.Item(0).Id = "Document\CH02"

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

ContProp.ContainedObjects.Add

ContProp.ContainedObjects.Item(1).Id = "Document\CH01"

ContProp.ContainedObjects.Item(1).Text.v = "StraightTable"

ContainerObj.SetProperties ContProp

If I try to run the macro, I get an Error at the line "ContProp.ContainedObjects.Item(0).Id" with the Message

"Object does not support this this Property or Method: 'ContProp.ContainedObjects.Item(...).Id'

I´m currently using QlikView 11.20 SR 13. Did anybody get a similar macro to run or has an Idea why it fails ? Unfortunatelly the API-Guide is not complete for working with Containers, I don´t know where to get further Infomation about that.

I attached an example with two charts an the macro, which anybody could try.

Thanks in Advance !

Best Regars

Florian

Re: Add SheetObject (Straight-Table) to Container with Macro

marcus_sommer — Wed, 06 Jul 2016 11:47:12 GMT

Have a look here: Re: How to add object to container with Grid layout via VBS

- Marcus

Re: Add SheetObject (Straight-Table) to Container with Macro

tamilarasu — Wed, 06 Jul 2016 12:42:02 GMT

Hi Florian,

Try this,

Sub Container

Set ContainerObj = ActiveDocument.Sheets("Main").CreateContainer

set ContProp=ContainerObj.GetProperties

ContProp.ContainedObjects.Add

ContProp.SingleObjectMode=1

ContProp.SingleObjectStyle=1

ContProp.ShowObjectTypeIcons=true

ContProp.ContainedObjects.Add

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

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

ContProp.ContainedObjects.Add

ContProp.ContainedObjects.Item(1).Def.ObjectId = "Document\CH01"

ContProp.ContainedObjects.Item(1).Text.v = "StraightTable"

ContainerObj.SetProperties ContProp

End Sub

Re: Add SheetObject (Straight-Table) to Container with Macro

sasiparupudi1 — Wed, 06 Jul 2016 13:48:56 GMT

Try following

Sub AddChartsToContainer

Set ContainerObj = ActiveDocument.Sheets("Main").CreateContainer

set ContProp=ContainerObj.GetProperties

ContProp.ContainedObjects.Add

ContProp.SingleObjectMode=1

ContProp.SingleObjectStyle=1

ContProp.ShowObjectTypeIcons=true

ContProp.ContainedObjects.Add

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

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

ContProp.ContainedObjects.Add

ContProp.ContainedObjects.Item(1).Def.ObjectId = "Document\CH01"

ContProp.ContainedObjects.Item(1).Text.v = "StraightTable"

ContainerObj.SetProperties ContProp

END SUB