Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Export table structure of Qlikview Document using macro.

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                              

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Creator
Creator

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.