topic Re: Export Object ID and Object Properties into Excel from Qlikview in QlikView

Export Object ID and Object Properties into Excel from Qlikview

Tue, 03 Jun 2014 11:25:21 GMT

Hi All,

We have around 300 objects in our dashboard, and I would like to export all the object ID and properties into an Excel worksheet.

Please let me know if this is possible and how.

Many thanks in advance.

Re: Export Object ID and Object Properties into Excel from Qlikview

ashfaq_haseeb — Tue, 03 Jun 2014 11:28:56 GMT

go to setting and expression overview select your required option and click export.

Image attached.

Regards

ASHFAQ

Re: Export Object ID and Object Properties into Excel from Qlikview

Tue, 03 Jun 2014 11:38:18 GMT

Hi Ashfaq,

Thanks but if you read the problem I want to export the object ID and its properites not the expression.

Any help would be appriciated.

Re: Export Object ID and Object Properties into Excel from Qlikview

ashfaq_haseeb — Tue, 03 Jun 2014 11:43:33 GMT

Hi,

Amir,

In this export you get object ID, what exactly you mean by properties.

do you mean chart properties? you cannot export that.

Regards

ASHFAQ

Re: Export Object ID and Object Properties into Excel from Qlikview

marcus_sommer — Tue, 03 Jun 2014 13:44:20 GMT

You could read/load the qvw itself or used for this reason the export from document layout (tab file --> export) within another qvw and could it then export to excel.

- Marcus