topic Re: When to use LET and SET Statements? in QlikView

When to use LET and SET Statements?

Wed, 12 Nov 2014 12:40:32 GMT

Hello!

Can anyone please tell me when to use LET Statement and SET Statement? I am finding it hard to understand the difference between using the two statements.

Thank you!

Re: When to use LET and SET Statements?

marcus_malinow — Wed, 12 Nov 2014 12:43:47 GMT

A LET statement will evaluate the expression after the equals sign, whereas a SET statement will put whatever expression you have after the equals sign into your variable.

LET x = max(Date);

will put the value of max(Date) in your variable

SET x = max(Date)

will put the string 'max(Date)' into your variable

Re: When to use LET and SET Statements?

rubenmarin — Wed, 12 Nov 2014 12:46:12 GMT

Hi Michael,

SET is used to assign a vlue to a variable 'as is'.

LET is used when the variable is assigned in some calculation

So, if you use

SET var = 1+1 --> var contains '1+1'

LET var = 1+1 --> var contains '2'

Re: When to use LET and SET Statements?

ashfaq_haseeb — Wed, 12 Nov 2014 13:01:22 GMT

Hi,

Check this

let and set difference

Regards

ASHFAQ