Variable with equal sign ("=")

[mhmmd_srf]

Hi All,

I am going through a Qlik performance tuning slide. There is a topic call "No of Calculation on every click".

It is mentioned there that certain calculations will get performed on every click, like :

Variable that begins with equal sign "=".

I was searching through google, however did not get any proper explanation.

Could anyone help me to understand that.

Thanks,

MS

[Somasundaram]

Hi Mhmmd_srf,

if you are using '=' before variables, It will evaluate the expression and store the value.

So each and every time it will calculate the expression.

Hope it will help.

[agni_gold]

Variables which are starting with "=", are called precalculated variable, and they will be calculated before the execution of expression.
while
Variables which are not starting with "=", they will be calculated at runtime.

[mhmmd_srf]

I am bit confused now.

so which one is good for performance? Could you please give an example for both the cases.

Thanks,

MS

[Somasundaram]

you can use with out '=', because , we no need to pre calculate values.

with out using the '='

example-   a  = 10+20, b 10+20

In this case both the variables will give 30 as the value.

suppose, if you are passing the values in run time. it will not give the same value.

[sathishbabu_s_g]

Hi MS,

Variable in Qlikview can be two types, either static or calculative. Perhaps the below link will explain you better.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Magic-of-Variables/ba-p/1465499

With Regards,
Sathish
sathishbabu.s.g@gmail.com

[marcus_sommer]

It's not really a performance-question because it depends on your requirements which type of variable you need and usually there is no choice between them.

- Marcus