Reusing Expressions

Josh_Good — Fri, 20 Apr 2012 16:30:56 GMT

Learn how to reuse expression with a QlikView document and between multiple QlikVie documents.

VariablesTable:

LOAD VariableName,

VariableValue

FROM

[QVDStore\VariablesTable.QVD]

(qvd);

//* Set Equation variables

//* The following loop allowing for loading numerous variables dynamically,

//* without having to call them by name.

for i=0 to noofrows('VariablesTable')-1

LET var_name= peek('VariableName',i,'VariablesTable');

LET $(var_name) = peek('VariableValue',i,'VariablesTable');

TRACE Load Variable: $(var_name) = $($(var_name));

next i

Drop Table VariablesTable;

topic Reusing Expressions in QlikView