Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I show you my idea, I Would you my terms of fattening and expressions analysis in Excel File Not With Variables, and then my recharger Initiation and Variables USE In My objects, but I can not part Manage aside reload QlikView, somebody can explain to me the process please e a small example application.
Thank you for your help
Regards,
Maurice
No this is not correct, that load script will automatically loop through and create all 1500 variables.
Maurice please see here for the example from Qlik IT
Hi,
First create variable in dashboard:
Ctrl+Alt+v, create new variables.
Change expressions to variables
now create input box object and select expressions variables and export to excel
out of 3 columns delete "=" column and use below mentioned script to load the variables by giving appropriate path
Formulas:
LOAD Variable,
Formula
//Remarks
FROM
(ooxml, embedded labels, table is VariablesTab);
Let vNumberOfRows = NoOfRows('Formulas');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('Variable',vI,'Formula');
Let [$(vVariable_Name)] = Peek('Formula',vI,'formula');
Next
Thank you very much Sasi V Kandragula,
Let vVariable_Name = Peek('Variable',vI,'Formula');
Let [$(vVariable_Name)] = Peek('Formula',vI,'formula');
Next
.
I have to declare every variable here, I almost 1500 variable (expression)
Yes we need to declare all expressions(Variables) in our dashboard.
In script? I can also declare in text file that reference the Excel file
No this is not correct, that load script will automatically loop through and create all 1500 variables.
Maurice please see here for the example from Qlik IT
If we place all variable sin excel sheet and load above mentioned script
Let vNumberOfRows = NoOfRows('Formulas');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('Variable',vI,'Formula');
Let [$(vVariable_Name)] = Peek('Formula',vI,'formula');
Next
It will load all 1500 variables..not required any code change or manual declaration of each variable.
Thank you very much Adam