topic Re: Export sheetID and ObjectID to excel file in QlikView

Export sheetID and ObjectID to excel file

limingthefirst — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have a request is that export all sheetIDs and ObjectIDs to an excel file using macro, but I am new in VBS, could anybody give some sugesstions?

Re: Export sheetID and ObjectID to excel file

berndjaegle — Wed, 11 Apr 2018 12:49:51 GMT

Hi Li Ming,

I would try to extracte it with the Governance Dashboard App.

There is menue where you can find objects.

You could export it manually to Excel or try to store it as qvd in the script.

Best regards,

Bernd

Re: Export sheetID and ObjectID to excel file

sudeepkm — Wed, 11 Apr 2018 12:59:38 GMT

you may use Document Analyzer created by rwunderlich‌

Document Analyzer V3.0 Update Available‌

It has a tab that shows Object details. The Doc analyzer file size is also small (downloadable).

Re: Export sheetID and ObjectID to excel file

vvira1316 — Wed, 11 Apr 2018 13:12:50 GMT

You may want to understand Document Analyzer from rwunderlich‌

In this when an application is analyzed it captures various information that includes sheet ids and object ids.

I hope this helps.

Re: Export sheetID and ObjectID to excel file

limingthefirst — Wed, 11 Apr 2018 13:29:56 GMT

Thank all your sugesstions~

I can not open the download link in qlik for Governance Dashboard App...

Then I try to use Document Analyzer, and this is not what I wanted.

Just use macro to export sheetID and ObjectID when the qvw had been reloaded by QMC~

Re: Export sheetID and ObjectID to excel file

sudhirpkuwar — Wed, 11 Apr 2018 13:35:09 GMT

Not sure about exporting to excel, but you can export to txt file

Go to Settings--->Expression Overview

Select Chart Expression

Click on Columns and select the below

and then Select Export

Export in a txt file

Re: Export sheetID and ObjectID to excel file

rwunderlich — Thu, 12 Apr 2018 21:04:40 GMT

What are you going to do with the information?

Easier than a macro -- which is can be difficult to run reliably on the server -- is to load the SheetIds and ObjectIds using QlikView script and STORE in a csv file.

-Rob

Re: Export sheetID and ObjectID to excel file

rwunderlich — Sat, 21 Apr 2018 16:44:52 GMT

Here is the script to export a list of sheets and objects to a csv file for the current document.

LET vDocumentPath = DocumentPath();

SheetObject:

LOAD SheetId,

Title as SheetTitle,

%Key_Sheet_A4D568A6CD8BD40A

FROM [$(vDocumentPath)] (XmlSimple, Table is [DocumentSummary/Sheet]);

Left Join (SheetObject)

LOAD ObjectId%Table as ObjectId,

%Key_Sheet_A4D568A6CD8BD40A

FROM [$(vDocumentPath)] (XmlSimple, Table is [DocumentSummary/Sheet/ChildObjects/ObjectId]);

DROP Field %Key_Sheet_A4D568A6CD8BD40A;

Left Join (SheetObject)

LOAD ObjectId,

Caption as ObjectCaption,

Type as ObjectType

FROM [$(vDocumentPath)] (XmlSimple, Table is [DocumentSummary/SheetObject]);

STORE SheetObject INTO SheetObject.csv (txt);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Export sheetID and ObjectID to excel file

limingthefirst — Tue, 15 May 2018 08:53:14 GMT

Hi Rob,

Thanks your suggestion, it worked~