topic When to use = in expression in QlikView

When to use = in expression

Fri, 21 Mar 2014 16:37:05 GMT

Hi,

I want to know when to start the expression with =?

Sometimes if the expression if not giving required results, developers simply add = and then it starts working. Is there is thum rule when it needs to be used?

what I have observed is if you want to return the value stored in the variable then you need to give =$(variable)...not giving = returns the expression itself (without evaluating the result). Can you please guide on this?

Regards,

Omnu

Re: When to use = in expression

SunilChauhan — Fri, 21 Mar 2014 16:41:34 GMT

when you define using Let keyword

id automatically take equal to

i mean it will calculate expression after variable in let

and when use set Keyword is will not calculate i.e not use equal

ex:

Let a=1+2 results in 3

set a=1+2 results in 1+2

but when you use

=$(a) IT WILL RESULT IN 3

HOPE THISHELPS

Re: When to use = in expression

its_anandrjs — Fri, 21 Mar 2014 16:56:46 GMT

Hi,

When using a variable for text replacement in the script or in an expression, the following syntax is used:

$( variablename )

And for assigning the value to any variable we used

Let vYear = $(CurrentYear);

and if using like this

Set X = $(MUL(3,7)); // returns '3*7' in X

Let X = $(MUL(3,7)); // returns 21 in X

Hope this helps

Thanks & Regards

Re: When to use = in expression

Nicole-Smith — Fri, 21 Mar 2014 17:14:36 GMT

This is a good article/explanation:

http://www.qlikfix.com/2011/06/08/not-all-variables-are-created-equal/