topic Re: Text Object Creation via Macro in QlikView

Text Object Creation via Macro

Wed, 30 Mar 2016 06:16:48 GMT

Hi All,

i am trying to create a Text object Object using macro below is the code.

set obj = ActiveDocument.ActiveSheet.CreateTextObject

prop = obj.GetProperties

'Image Presentation

prop.Layout.Text.v = "= 'qmem://ImageId/arrowU_off'

prop.Layout.ImageRepresentation.Presentation=1

prop.Layout.ImageStyle.StrechMode=0

i am able to create a text object which represent Image successfully, but issue is that Image StrectMode is ON which i want to OFF by using macro only i have tried the code prop.Layout.ImageStyle.StrechMode=0 but this is not working.

Please help how to do this.

Thanks & Regards,

Jitendra Kumar.

Re: Text Object Creation via Macro

petter — Wed, 30 Mar 2016 08:16:41 GMT

In you code I can't find a

obj.SetProperties prop

Which is necessary to activate the changes you have made on the object you are manipulating...

Re: Text Object Creation via Macro

tamilarasu — Wed, 30 Mar 2016 08:19:38 GMT

Hi Jitendra,

Try the below syntax,

prop.Layout.BkgImageSettings.ImageStyle.StretchMode = 0

Re: Text Object Creation via Macro

Wed, 30 Mar 2016 08:33:07 GMT

In code i am doing obj.SetProperties prop

Re: Text Object Creation via Macro

Wed, 30 Mar 2016 08:43:24 GMT

Hi Tamil Nagaraj,

i have tried that. its did not giving me any error but still it not working.

Re: Text Object Creation via Macro

Wed, 30 Mar 2016 09:29:11 GMT

Hi Tamil Nagaraj,

using you code is changing red marked properties, i want to change blue marked property of text object.

Re: Text Object Creation via Macro

tamilarasu — Thu, 31 Mar 2016 02:34:33 GMT

Hi Jitendra,

I have found it after a long search. But I felt frustrating to search the correct syntax to access the properties through macro. Lack of examples in API guide.

Sub Test

set obj = ActiveDocument.ActiveSheet.CreateTextObject

prop = obj.GetProperties

'Image Presentation

prop.Layout.Text.v = "= 'qmem://ImageId/arrowU_off' "

prop.Layout.ImageRepresentation.Presentation=1

prop.Layout.ImageRepresentation.CellImageStyle.StretchMode = 0

obj.SetProperties prop

End Sub

Let me know.

Re: Text Object Creation via Macro

Thu, 31 Mar 2016 07:32:08 GMT

Thanks Tamil nagaraj,

Its working fine.

Agree with your point i am also very frustrated to search the correct syntax.

Re: Text Object Creation via Macro

5abi0001 — Wed, 28 Feb 2018 12:21:41 GMT

Is it also possible to set actions via macro? like when creating the textbox to set actions like run a macro?

Re: Text Object Creation via Macro

tamilarasu — Wed, 28 Feb 2018 18:45:32 GMT

Yes. It is possible. I would suggest you to create a new discussion since this one is already closed and more than 2 year old. Hope this is fine with you. Don't forget to mention my name after creating a new discussion, so that I'll get a notification. Have a nice day.