Learn how to reuse expression with a QlikView document and between multiple QlikVie documents.
Here is the script mentioned in the video:
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;
