topic Re: Macro creation of Objects in QlikView

Macro creation of Objects

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Within a macro script I can retrieve objects and all kinds of information. The API Guide version 11 I can find Application Classes, Document Classes, Sheet Classes and all kinds of properties. With underneath statements I can simply find the Object typename from an object called Test1:

set obj = ActiveDocument.GetSheetObject("Test1")

msgbox Typename(obj)

I cannot find any example of a method to create an new How can I for instance create a new Tablebox object.

Does anyone has an example of how to create an empty Tablebox object?

With regards, Floris

Re: Macro creation of Objects

Chanty4u — Fri, 25 Mar 2016 09:52:34 GMT

did u chk dis?

Useful Qlikview Macros

Re: Macro creation of Objects

Fri, 25 Mar 2016 09:56:34 GMT

Thank Chanty for your reply.

Yes, I check those example macro scripts. I can only find Copy examples, but no creation of any objects.

Re: Macro creation of Objects

Gysbert_Wassenaar — Fri, 25 Mar 2016 09:59:05 GMT

Afaik it's not possible to create an empty table box. It will always need at least one field.

You can use the CreateTableBox method to create the table box:

set TB = ActiveDocument.Sheets("Test1").CreateTableBox

TB.AddField "MyField"

Re: Macro creation of Objects

tresB — Fri, 25 Mar 2016 10:00:58 GMT

set TB = ActiveDocument.Sheets("Products").CreateTableBox

TB.AddField "ProductType"

TB.AddField "Product"

Re: Macro creation of Objects

Peter_Cammaert — Fri, 25 Mar 2016 10:05:40 GMT

There are quite a few Create... methods in the interface library. One for every Graph type for example.

In the API Guide, navigate to sheet "Automation Examples". In listbox Member, search for "Create*".

Best,

Peter

Re: Macro creation of Objects

Fri, 25 Mar 2016 10:12:11 GMT

Tnx Gijsbert, this is very usefull.

Re: Macro creation of Objects

Fri, 25 Mar 2016 10:12:35 GMT

Tnx Marco, I can use this.

Re: Macro creation of Objects

Fri, 25 Mar 2016 10:15:05 GMT

Peter,

I missed that sheet completely, tbnx for the information. Now I can create new objects from scratch.

Re: Macro creation of Objects

Peter_Cammaert — Fri, 25 Mar 2016 12:51:00 GMT

No problem, we're here to help and we're glad we could.

If you feel your question has been suitably answered, please mark one of the answers before mine as correct. If you feel other answers have been Helpful, please mark them as such. Thanks.

Peter

Re: Macro creation of Objects

Fri, 25 Mar 2016 14:19:09 GMT

I only have the option "Mark as Helpful" in the Actions list.

Re: Macro creation of Objects

Peter_Cammaert — Fri, 25 Mar 2016 14:54:12 GMT

As you seem to have found out already, the Correct Answer marker is a button that appears on top of each post in a thread you created. If you are reading this thread in your inbox, you won't get the green button. Open the discussion in a full frame by clicking the blue header text, and all features will be made available to you.

Good luck,

Peter