topic Re: setting variables in the most efficient way in QlikView https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866272#M1008828 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>With regards to calculation time: Qlikview will cache results of expressions. You may not notice any difference because of that caching.</P></BODY></HTML> Mon, 04 May 2015 08:11:51 GMT Gysbert_Wassenaar 2015-05-04T08:11:51Z setting variables in the most efficient way https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866271#M1008827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>There's a variable (e.g. Variable1) which is used extensively throughout the application as part of other expressions and variables.</P><P></P><P>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.</P><P></P><P>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.</P><P>What's your opinion?</P><P></P><P>If I have to do it, is it possible to make an automatic renaming of <SPAN style="font-size: 13.3333330154419px;">$(Variable1) to Variable1 throughout the application?</SPAN></P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Sat, 02 May 2015 17:23:39 GMT https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866271#M1008827 Anonymous 2015-05-02T17:23:39Z Re: setting variables in the most efficient way https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866272#M1008828 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>With regards to calculation time: Qlikview will cache results of expressions. You may not notice any difference because of that caching.</P></BODY></HTML> Mon, 04 May 2015 08:11:51 GMT https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866272#M1008828 Gysbert_Wassenaar 2015-05-04T08:11:51Z Re: setting variables in the most efficient way https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866273#M1008829 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 05 May 2015 08:11:22 GMT https://community.qlik.com/t5/QlikView/setting-variables-in-the-most-efficient-way/m-p/866273#M1008829 Anonymous 2015-05-05T08:11:22Z