topic Error in Macro code in QlikView

Error in Macro code

spsrk_84 — Fri, 07 Dec 2012 07:37:22 GMT

Hi All,

I am working on QV 10 SR3 (64 bit) Qlikview Desktop .I am facing issue with the below code

Error Message : Object required: 'ActiveDocument.Variables(...)'

sub GetActiveIndex

Set ContainerObj= ActiveDocument.GetSheetObject("CT30")

Set ContProp=ContainerObj.GetProperties

vActiveIndex=ContProp.SingleObjectActiveIndex

ActiveDocument.Variables("vActiveIndex").SetContent vActiveIndex, true

msgbox vActiveIndex

End Sub

Please check the code help to resolve this issue in this code

Regards,

Shiva

flipside — Fri, 07 Dec 2012 07:47:24 GMT

Hi Shiva,

You need to get the variable as well as the object like this example in the API Guide ...

set v = ActiveDocument.GetVariable("Variable1")

v.SetContent "123",true

flipside

spsrk_84 — Fri, 07 Dec 2012 11:47:07 GMT

The error occured because the variable vActive Index is not created .

flipside — Fri, 07 Dec 2012 17:02:52 GMT

Of course ... looks like there's two ways to set the variable! I've gotten into the habit of always getting then setting.

set v = ActiveDocument.Variables("Variable1")

v.SetContent "123",true

flipside