topic Re: set and let in QlikView

set and let

maniram23 — Mon, 20 Apr 2015 08:40:28 GMT

what is the difference between set and let?

Re: set and let

morganaaron — Mon, 20 Apr 2015 09:29:17 GMT

Both assign values to variables in the script - SET assigns the value to the variable without evaluation, as a string, whereas LET first evaluates the expression on the right of the equals sign, then stores it.

There's a good explanation of it here (see the correct answer) by Miguel: Re: $(#variable) when variable is NULL: general script error, why?

Re: set and let

rubenmarin — Mon, 20 Apr 2015 09:32:13 GMT

Hi mani,

Set: Creates a variable with a defined string or number, ie: SET vPath = ".\AuxDocs";

Let: Defines a variable that can be evaluated, ie: LET vFile = vPath & '\file.txt'; --> vFile will store .\AuxDocs\file.txt

Re: set and let

Agis-Kalogiannis — Mon, 20 Apr 2015 09:34:52 GMT

A very simple example:

If you create two variables in the script:

SET x = 2 + 3;

and

LET y = 2 + 3;

on the front end,

x will be equal to '2+3' and y will be equal to 5.

Re: set and let

ger_alegria — Mon, 13 Jul 2015 22:32:18 GMT

SET give a value of a String to a variable, i.e:

Set variable = 3*2;

variable = '3*2'

and LET evaluates the expresión on the right of equals sign, i.e:

LET variable = 3*2;

variable = 6

Ger