topic Re: Macro to delete charts from container in QlikView

Macro to delete charts from container

Thu, 28 Aug 2014 03:40:44 GMT

Hi,

I have some n charts inside a container, I want to delete them by looping through all objects in the container.

Can someone tell me how to do this using a macro.

Thanks,

Jyotsna

jagan — Thu, 28 Aug 2014 04:14:37 GMT

Hi,

Try like this not sure it works.

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

set ContProp=ContainerObj.GetProperties

ContProp.ContainedObjects.Item(0).Remove

ContProp.ContainedObjects.Item(0).Delete

Regards,

Jagan.

Thu, 28 Aug 2014 04:18:57 GMT

I tried all of Remove, Delete and Close, nothing seems to be working.

Thanks,

Jyotsna

Sun, 31 Aug 2014 23:56:25 GMT

Got it finally

Set ContainerObj = ActiveDocument.GetSheetObject("CT01")

Set ContProp = ContainerObj.GetProperties

for i=0 to ContProp.ContainedObjects.Count-1

ContProp.ContainedObjets.RemoveAt(0)

ContainerObj.SetProperties ContProp

Hope this helps someone

jagan — Mon, 01 Sep 2014 02:36:03 GMT

Great. Not given this in APIGuide.

Regards,

Jagan.