topic Exporting variables in QlikView

Exporting variables

sczetty — Wed, 24 Jun 2009 20:45:25 GMT

I have a large application with too many variables to document esily. Is there a method to export all the variables into a file for documentation puposes/

Exporting variables

disqr_rm — Wed, 24 Jun 2009 20:51:30 GMT

You can use a VB macro to store them in a text file or clipboard.

From API Guide:

rem ** Show name of all variables in document **
set vars = ActiveDocument.GetVariableDescriptions
for i = 0 to vars.Count - 1
set v = vars.Item(i)
msgbox(v.Name)
next

THis will loop through all the document variables, and within the for-next loop you can insert a line in a text file.

Hope this helps.

Exporting variables

sczetty — Wed, 24 Jun 2009 21:01:05 GMT

Thanks, this looks like a good workaround to a missing feature!

Steve