topic Re: Variable Excel in QlikView

Variable Excel

MauriceLudo — Wed, 12 Oct 2016 08:11:33 GMT

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

Re: Variable Excel

vardhancse — Wed, 12 Oct 2016 08:32:26 GMT

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

\\Desktop\Variables.xlsx

(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');

Re: Variable Excel

MauriceLudo — Wed, 12 Oct 2016 08:43:59 GMT

Thank you very much Sasi V Kandragula,

Let vVariable_Name = Peek('Variable',vI,'Formula');

Let [$(vVariable_Name)] = Peek('Formula',vI,'formula');

.....

I have to declare every variable here, I almost 1500 variable (expression)

Re: Variable Excel

vardhancse — Wed, 12 Oct 2016 08:46:34 GMT

Yes we need to declare all expressions(Variables) in our dashboard.

Re: Variable Excel

MauriceLudo — Wed, 12 Oct 2016 08:51:54 GMT

In script? I can also declare in text file that reference the Excel file

Re: Variable Excel

adamdavi3s — Wed, 12 Oct 2016 08:55:24 GMT

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

Managing Variables

Re: Variable Excel

vardhancse — Wed, 12 Oct 2016 09:03:23 GMT

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');

It will load all 1500 variables..not required any code change or manual declaration of each variable.

Re: Variable Excel

MauriceLudo — Wed, 12 Oct 2016 09:51:00 GMT

Thank you very much Adam