When does a variables content get calculated?

helen_pip — Fri, 11 Apr 2014 11:07:59 GMT

Hello

I have stored all my expressions as variables

I have stored every variable in a spreadsheet and then use the following syntex to load in the variables

Expressions:

LOAD Variable,
Replace(Expression, '$', '#') As Expression
FROM

(biff, embedded labels, table is [Formulas$]);

Let vNumberOfRows =

NoOfRows('Expressions');

For

vI = 0

to (

vNumberOfRows - 1)

Let

vVariable_Name =

Peek('Variable',

vI,'Expression');

Let

[$(vVariable_Name)] =

Replace(

Peek('Expression',

vI,'Expression'), '#', '$');

Next

My chart are now looking at the variables, as I have been told that it will stop the chart calculating the informatoin "on the fly"

So if my charts are not calculating information on the fly anymore, when is the variable performing the calculation and storing the values?

Is it as the spreadsheet loads in?

Any help on understanding why I have been told to take this approach to improve "End user experience" would be greatly appreciated

Thanks

Helen

Re: When does a variables content get calculated?

Gysbert_Wassenaar — Fri, 11 Apr 2014 11:16:03 GMT

yduval75 — Fri, 11 Apr 2014 11:19:05 GMT

I think this method can help you to download variables from an excel file.