topic Re: let a=b+2 what will happend? in QlikView

let a=b+2 what will happend?

Fri, 28 Feb 2014 13:50:29 GMT

what is the result?

how can I check the let and set values in QlikView?

Ex: Let a=b+2

where I have to see the answer?

how to use this one?

Thanks In advance...

venu'

Re: let a=b+2 what will happend?

Peter_Cammaert — Fri, 28 Feb 2014 13:53:13 GMT

Put text boxes on a sheet, with a text expression like ='The value of variable a = [$(a)]'

Multiple expressions can be concatenated using & and the chr(10) line separator.

Peter

Re: let a=b+2 what will happend?

marcus_malinow — Fri, 28 Feb 2014 13:53:23 GMT

Venu,

after your script has loaded, open the variable viewer (CTRL + ALT + V).

This will show you the values you have assigned to your variables.

For reference, this blog post may be useful - http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

Marcus

Re: let a=b+2 what will happend?

ashwanin — Fri, 28 Feb 2014 13:58:37 GMT

After Loading data in QlikView use Input Box to check your expression.

Re: let a=b+2 what will happend?

ThornOfCrowns — Fri, 28 Feb 2014 14:00:58 GMT

Be aware that there is a difference between LET and SET

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

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

Re: let a=b+2 what will happend?

mjm — Fri, 28 Feb 2014 15:09:45 GMT

Hello Venu,

If you want to see the values of this LET statement, then there is also the option of looking at the values during the script execution. When you are in the script module then there is the option of 'Debug' where you can see the current state of variables in a script as you run through the steps in the script.

Alternatively, if you want to view the variables in the front end, then the options already mentioned above are useful.

Please mark this as useful, if this helps you.

Thanks,

Mark

Re: let a=b+2 what will happend?

maxgro — Fri, 28 Feb 2014 22:19:17 GMT

if you want to check in your script (during execution) use trace or debug

SCRIPT

SET vSetTest=4+5;

trace SET $(vSetTest);

LET vLetTest=4+5;

trace LET $(vLetTest);

RESULT in script execution progress window

SET 4+5

LET 9