Import Variables from Excel and assign to client advisor

[madmax88]

Hi,

I imported variables from Excel into Qlik Sense Script, but it can't be assigned to a client advisor. How can I do it?

In Script I have following:

Expressions:
LOAD
Variable,
Expression,
Comment
FROM [lib://Mapping/Mastertable_Variabl.xlsx]
(ooxml, embedded labels, table is Tabelle1);

Let vNumberOfRows = NoOfRows('Expressions');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('Variable',vI,'Expression');
Let [$(vVariable_Name)] = Peek('Expression',vI,'Expression');
Next

And the Table is:

Variable

Expression

Comment

The variable import is working, but when i want the variable by client advisor it calculate for each the same value.

Any idea?

[marcus_sommer · Accepted solution]

It sounds that your variables starts with an equal sign - in this case they are evaluated at ones (and without any dimensionality) and only the result of the calculation is the assigned to the variable. For this just remove the equal sign so that the variable contains the expression-string.

- Marcus

[madmax88]

It works, Thanks!