Reusing Expressions

[Josh_Good]

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

www.youtube.com/watch?v=hhGX3ohwxrY

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;