topic Re: Variable with equal sign ("=") in QlikView

Variable with equal sign ("=")

mhmmd_srf — Sat, 16 Nov 2024 04:51:58 GMT

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,

Re: Variable with equal sign ("=")

Somasundaram — Wed, 02 Jan 2019 12:35:40 GMT

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.

Re: Variable with equal sign ("=")

agni_gold — Wed, 02 Jan 2019 12:36:19 GMT

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.

Re: Variable with equal sign ("=")

mhmmd_srf — Wed, 02 Jan 2019 12:51:12 GMT

I am bit confused now.

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

Thanks,

Re: Variable with equal sign ("=")

Somasundaram — Wed, 02 Jan 2019 13:03:05 GMT

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.

Re: Variable with equal sign ("=")

sathishbabu_s_g — Wed, 02 Jan 2019 13:17:55 GMT

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

Re: Variable with equal sign ("=")

marcus_sommer — Wed, 02 Jan 2019 15:15:43 GMT

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