Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Variable with equal sign ("=")

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

 

Labels (2)
6 Replies
Somasundaram
Creator III
Creator III

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.

 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
agni_gold
Specialist III
Specialist III

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
Creator II
Creator II
Author

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
Creator III
Creator III

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.

 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
sathishbabu_s_g
Contributor III
Contributor III

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