Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone. I have two questions regarding data export in Qlik Sense:
1.Is there a possibility to save data in an Excel file, but in different Sheets?
2.Is it possible, using the STORE function in the Data Load Editor, to export the values of variables (variables are also calculated in the script)?
Thanks,
Dusan
1. Not that I know of.
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;
Thaks a lot!
I'll be more precise about secon question.
I have two variables:
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'.
Thank you in advance.
You can add them as measures to a table that you can export:
I tried to solve it this way:
P.S. I'm using Partial Reload for data export.