setting variables in the most efficient way

[Anonymous]

Hi,

There's a variable (e.g. Variable1) which is used extensively throughout the application as part of other expressions and variables.

Variable1 contains an expression which calculates a singal value - a parameter needed for the other expressions. It was created initially without an equal sign, so when refering to it I use the following syntax: $(Variable1). It means that the expression in expanded and then evaluated in each and every expression where it is part of.

It is quite obvious to me that I could set an equal sign for my variable in the variable window and then refer to it simply as Variable1 without a dollar sign. It means that it won't be expanded, it will be regarded as a parameter. But the result will be quite the same in terms of correctness. I've checked it. The question is if it can speed up the application. I'm not sure of it. Maybe, if it doesn't expand and regarded as a parameter, it will help to save time to caclulate.

What's your opinion?

If I have to do it, is it possible to make an automatic renaming of $(Variable1) to Variable1 throughout the application?

Thank you in advance,

Larisa

[Gysbert_Wassenaar · Accepted solution]

If you define Variable1 as =Sum(Sales) then you can use =Variable1 in a text box. But using =Variable1 as a chart expression won't work. You'll have to use $(Variable1). And then only if you don't want the expression Sum(Sales) evaluated in the context of the dimension values of the chart. Otherwise you'll have to define Variable1 as Sum(Sales) without the = character. So, I don't think you can replace $(Variable1) with Variable1 everywhere.

With regards to calculation time: Qlikview will cache results of expressions. You may not notice any difference because of that caching.

[Anonymous]

Thank you!