topic Macro to list all Variable names in QlikView

Macro to list all Variable names

markmccoid — Fri, 24 Apr 2009 21:20:03 GMT

Not sure why I can't find this but I need to create a macro that will return all the variable names in a document.

Anybody know how to do this?

Thanks

Mark

Macro to list all Variable names

Anonymous — Fri, 24 Apr 2009 21:32:44 GMT

You should use this function GetVariableDescriptions in your macro. You can find it in the APIGuide.qvw

Example in the APIGuide.qvw :

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

Macro to list all Variable names

markmccoid — Fri, 24 Apr 2009 21:55:12 GMT

Sometimes I can look at that API app all day and not find what was starring me in the face!

Thanks!

Mark