topic LET and SET in QlikView

LET and SET

Mon, 24 Oct 2011 05:50:55 GMT

What is the use of LET and SET? What is the difference between them?

Thanks

Attitude

Re: LET and SET

Miguel_Angel_Baeyens — Mon, 24 Oct 2011 07:18:22 GMT

Hi,

As you can see in the Reference Manual, they are used to assign values to variables in the load script. The main difference is that while SET assigns the value to the variable without evaluation, as a string, the LET first evaluates the expression at the right part of the "=" sign, then stores the value.

Two simple examples:

SET vLiteral = 1 + 1; // This stores the string "1 + 1";
LET vSum = 1 + 1; // This stores 2

Check for further reference the Manual and this thread on how they work and when and how to expand and this other one among many others.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: LET and SET

its_anandrjs — Mon, 24 Oct 2011 08:23:12 GMT

Hi,

The Set command assigns the variable the text to the right of the equal sign, whereas the Let command evaluates the expression

set variablename = string

let variable = expression

Rgds

Anand

Re: LET and SET

Mon, 24 Oct 2011 10:04:45 GMT

Hi,

Let and Set commands are used to define Script Variables. Any text or numeric value can be assigned to the script variables.

Examples:

Set V = $ ; ( Set- assigns the variable(V) the text(String) to the right of the equal sign)

Let vStart = num(makedate(2011)); (Let- evaluates the expression)

Set MUL = ’$1*$2’;

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

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

Regards

Apurva

LET and SET

its_anandrjs — Mon, 24 Oct 2011 10:05:31 GMT

Hi,

See the example like

Let T=now( );

It will give you exact time because the value of now( ) return value assign to Let T variable and it retun time value.

Set P=now( );

But SET will give and return the now( )

means what ever you write for code it accept it as string

Rgds

Anand

LET and SET

suniljain — Tue, 08 Nov 2011 04:41:30 GMT

Set x=3+4;

Let y=3+4

z=$(y)+1;

$(x) will be evaluated as ' 3+4 '

$(y) will be evaluated as ' 7 '

$(z) will be evaluated as ' 8 '

LET and SET

kamalqlik — Tue, 08 Nov 2011 05:23:42 GMT

It is very simple:

using SET you are adding string value to a variable
SET Variable1='4+5';
variable value is '4+5'

using LET you are adding an expression result to a variable
LET Variable1=4+5;
variable value is 9

Re: LET and SET

Wed, 23 Apr 2014 05:41:09 GMT

Hi,

In Qlikview there are two variable SET and LET.The difference between these two is that the SET statement assigns literal string to SET variable,where LET Statement first evaluate the string before assigning it

e.g.

Statement Value of variable

Set aVariable= 2+3; 2+3;

Let bVariable = 2+3; 5;

Re: LET and SET

kumarravi — Tue, 22 Mar 2022 15:28:12 GMT

It is very similar as they are named:

SET will just set the value and LET will let you define the expression/Value.

Example:

SET V_set = 1+3 // It will store the value of "1+3" in the variable V_set

LET V_let = 1+3 // It will store the value of 4 in the variable V_let

Re: LET and SET

Vijayqlik4171 — Tue, 22 Mar 2022 18:42:39 GMT

Let= Dynamic(eg Let Variable = 2*2 when you use variable some where you will get answer 4)
Set=static(eg Set Variable = 2*2 when you use variable some where you will get answer 2*2)