topic Dynamic table containing list of objectids in QlikView

Dynamic table containing list of objectids

Tue, 15 May 2012 11:02:17 GMT

This is my requirement.

whenever i reload the script one table should populate the objectids of the objects present in the sheet.

Is it possible??

Jason_Michaelides — Tue, 15 May 2012 11:12:21 GMT

Hmm - not sure about this. See if this link can help you:

rwunderlich — Tue, 15 May 2012 14:53:51 GMT

This should work on QV10 SR2 or later:

LET vDocPath = DocumentPath();

SheetObject:

LOAD ObjectId,

Caption,

Type

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

-Rob

Wed, 16 May 2012 05:15:49 GMT

Brilliant..... Thanks a lot Rob

Tue, 11 Aug 2015 06:29:58 GMT

Hi Rob,

this post is great. Can you additionally please tell me, how to integrate the objectname as well.

Thanks for you help.

Chris