Export table structure of Qlikview Document using macro.

[#1]

Hi All,

As we all know we have option to export table structure and related information about qlikview table present in data model. We can do this manually by going to Settings->Document Properties->Tables->Export Structure. But I want to automate it and export it using macro.

Can we do this using macro ? Please Help.

Thanks in Advance. Regards, Vivek                              

[stevedark]

Hi Vivek,

Did you find the way to do this?  I am looking to do it myself and I've not found any other documentation on the topic.

Thanks in advance,

Steve

[marcelo_7]

You have to make modifications like a loop for all fields and add tablename-information etc. but this is probably what you're looking for.

rem Displays tags for the field
set fld=ActiveDocument.GetFieldDescription("Alpha")
fTags = fld.Tags
dim Tags
Tags=""
for i=lbound(fTags) to ubound(fTags)
Tags=Tags & " " & fTags(i)
next
msgbox(Tags)

From the API-application the class IFieldDescription also has the Members "Name" and "SrcTables" which might help creating the total.