topic Re: LET and SET redefined in QlikView

LET and SET redefined

deepali_more — Fri, 26 Feb 2016 07:51:09 GMT

Hello,

i know the difference between Let & Set keywords.but i have a scenario where in i have defined a variable using Set Keword but i waant to evaluate the string in that variable. How this can be achieved?

Re: LET and SET redefined

tamilarasu — Fri, 26 Feb 2016 10:44:16 GMT

Hi,

Like this.?

SET v1 = '4+5';

LET v2 = Evaluate(v1);

Re: LET and SET redefined

Gysbert_Wassenaar — Fri, 26 Feb 2016 10:46:20 GMT

Dollar expand it: LET vMySecondVar = $(vMyFirstVar);

Re: LET and SET redefined

hic — Fri, 26 Feb 2016 10:50:57 GMT

... or even simpler: Don't dollar-expand it.

Let vMySecondVar = vMyFirstVar;

HIC

Re: LET and SET redefined

tresB — Fri, 26 Feb 2016 10:55:44 GMT

Set vMyFirstVar = 5+6;

Let vMySecondVar = vMyFirstVar;

vMySecondVar doesn't seem to evaluate the string, it returns the string as it is.

In that case vMySecondVar would required to be dollar-expanded, right?

Re: LET and SET redefined

hic — Fri, 26 Feb 2016 11:02:43 GMT

You're right. I missed that. Evaluate or dollar expansion will both store 9 in the second variable, whereas the plain Let will store 4+5.

HIC