Showing posts with label Variable definition in Qlikview. Show all posts
Showing posts with label Variable definition in Qlikview. Show all posts

Wednesday, August 17, 2016

How to retrieve List of Variables along with their Definition in Qlikview?

Add below code in your script and run the script.
This will Add a table which will hold variable name and their definition. This value is from last reload(when the last time Dashboard was saved).

Let zFileName = DocumentPath();
Set ErrorMode = 0;

VariableDescription:
LOAD
  Name   As SOE.Name,
  RawValue   As SOE.Definition
FROM [$(zFileName)] (XmlSimple, Table is [DocumentSummary/VariableDescription])
Where Not(IsReserved = 'true' Or IsConfig = 'true');

Set zFileName = ;
Set ErrorMode = 1;