topic Re: Error in macro in QlikView

Error in macro

Anonymous — Mon, 01 Sep 2014 04:36:22 GMT

From API Guide>>>

sub ActiveOBJ

Set ContainerObj = ActiveDocument.GetSheetObject("CT01")

set ContProp=ContainerObj.GetProperties

ActiveObject=ContProp.SingleObjectActiveIndex

msgbox("Active Object=" & ActiveObject & " Id=" & ContProp.ContainedObjects.Item(ActiveObject).Id)

end sub

But this is giving error

Object doesn't support this property or method: 'ContProp.ContainedObjects.Item(...).Id'

Can anyone resolve it....

Re: Error in macro

v_iyyappan — Mon, 01 Sep 2014 05:14:50 GMT

Hi,

Please check below attached image for container macro.

Regards,

Re: Error in macro

Anonymous — Mon, 01 Sep 2014 05:29:31 GMT

Its not helping............

Re: Error in macro

jagan — Mon, 01 Sep 2014 05:34:42 GMT

Hi Nitin,

I am not sure why it is not working, but the work around for this is

Create two variables

vIndex : 1

vCurrentContainerObject : =Pick(vIndex + 1, 'CH01', 'CH02') //CH01 and CH02 are objects in container

Macro:

Function Test

Set ContainerObj = ActiveDocument.GetSheetObject("CT01")

set ContProp=ContainerObj.GetProperties

set v = ActiveDocument.GetVariable("vIndex")

v.SetContent ContProp.SingleObjectActiveIndex ,true

end function

Hope this helps you.

Regards,

jagan.

Re: Error in macro

tresB — Mon, 01 Sep 2014 05:37:20 GMT

Try like:

sub GetActiveIndex

Set ContainerObj= ActiveDocument.GetSheetObject("CT01")
Set ContProp=ContainerObj.GetProperties
vActiveIndex="You clicked tab number: " & ContProp.SingleObjectActiveIndex
ActiveDocument.Variables("vActiveIndex").SetContent vActiveIndex, true
msgbox vActiveIndex

End Sub

Re: Error in macro

Anonymous — Mon, 01 Sep 2014 05:44:14 GMT

By this how how I will get the activated object id(CHRT ID)

Re: Error in macro

jagan — Mon, 01 Sep 2014 06:02:41 GMT

Hi,

The variable vCurrentContainerObject will have the chart ID. You need to assign the macro to a button when clicked on button you will get.

Regards,

Jagan.

Re: Error in macro

Anonymous — Mon, 01 Sep 2014 06:30:32 GMT

But why the example in API guide is giving me error, Any IDEA???

Re: Error in macro

jagan — Mon, 01 Sep 2014 06:32:34 GMT

Not Sure Nitin, may be Community Adminstrator Sara Leslie can help in this. Not sure whether it is a bug, let them confirm.

Regards,

Jagan.