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;

1 comment:

  1. These lines really helped me out through, Could'nt thank more. keep posting such quick solutions. They really are of great help.

    Qlik Soap Api Connection

    ReplyDelete