2. You can store all variables in a table and export that table:
// Initialize Variable Table
Variables: NoConcatenate Load Null() as VariableName AutoGenerate 0;
// Calculate a Variable and add it to the Table
Let vVarPi = 3.14159265358979323;
Concatenate(Variables) Load
'vVarPi' as VariableName,
'$(vVarPi)' as VariableValue
AutoGenerate 1;
// Calculate a Variable and add it to the Table
Let vVarToday = Today();
Concatenate(Variables) Load
'vVarToday' as VariableName,
'$(vVarToday)' as VariableValue
AutoGenerate 1;
// Calculate a Variable and add it to the Table
Let vVarTest = 'Test';
Concatenate(Variables) Load
'vVarTest' as VariableName,
'$(vVarTest)' as VariableValue
AutoGenerate 1;
// Store Variable Table (Commented for Demo)
// Store Variables into 'xyz.qvd' (qvd);
// Drop Table Variables;
// Cleanup
Let vVarPi;
Let vVarToday;
Let vVarTest;
let WestSelection = fieldvalue('Country_West_selection', 1); // Only 'Germany' is in the field Country_West_selection
let pgr_west='min({<[Country_West]={$(WestSelection)}>}((Year_2020_West - Year_1970_West)/Year_1970_West)*100)'; // Formula for Population Growth Rate
I want to export data (as an Excel file) that will contain Country data - in this case, Germany, and the Population Growth Rate whose value is stored in the variable 'pgr'.
