Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
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

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
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
MVP & Luminary
MVP & Luminary

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