topic Create a listbox with all ObjectId? in QlikView

Create a listbox with all ObjectId?

Thu, 09 Sep 2010 09:40:20 GMT

I would like to create a listbox which contains all ObjectId:s.
Then I need to create a macro based on selected objects, for export to Powerpoint or Excel.

How?

/Elisabet

Create a listbox with all ObjectId?

willinek — Thu, 09 Sep 2010 09:49:42 GMT

Hi Elisabet,

you can export the document layout into a XML File. Than you can import this XML File as XML Data and parse out the <ObjectId> Field.

I think in the community you can find some examples of how to export to powerpoint

Alex

Create a listbox with all ObjectId?

Thu, 09 Sep 2010 10:02:00 GMT

OK, thanks, is it also possible to create the listbox in a macro?

Elisabet

Create a listbox with all ObjectId?

willinek — Thu, 09 Sep 2010 10:10:40 GMT

Of course that is possible,

but in generell Macros should be used carefully

set LB = ActiveDocument.Sheets("Main").CreateListBox
set BoxProp=LB.GetProperties
BoxProp.Def.Name = "Customer"
LB.SetProperties BoxProp

for more Details check out the APIguide.qvw in your AQv Installation folder

Alex