topic Re: Set Container Caption text using macro in QlikView

Set Container Caption text using macro

Wed, 27 Aug 2014 02:01:24 GMT

Hi,

I know the process of assigning caption text to container through macro is by creating a variable, assign the caption's text to this variable and then set variable value inside the macro, but this will only be applicable for existing container.

I have created my container through the macro, so I need to first assign the variable to the caption's text, but I don't know how to do this.

Any ideas?

Thanks,

Jyotsna

Re: Set Container Caption text using macro

jagan — Wed, 27 Aug 2014 02:41:20 GMT

Hi,

Try this

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

set ContProp=ContainerObj.GetProperties

set v = ActiveDocument.Variables("vVariable")

v.SetContent "Sales",true

end sub

Reference:

Changing a container caption via a macro

Regards,

Jagan.

Re: Set Container Caption text using macro

Wed, 27 Aug 2014 03:32:12 GMT

This is ok but how will the container's caption link to variable.

Thanks,

Jyotsna

Re: Set Container Caption text using macro

sujeetsingh — Wed, 27 Aug 2014 03:56:49 GMT

You need to call the variable in the caption i think.

Re: Set Container Caption text using macro

Wed, 27 Aug 2014 04:07:29 GMT

I need to do this from inside macro as the container is created using a macro.

Please let me know how to do this.

Thanks,

Jyotsna