Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
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
See this blog post: The Magic of Variables
I think this method can help you to download variables from an excel file.