Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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'
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
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
After Loading data in QlikView use Input Box to check your expression.
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
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
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