Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

let a=b+2 what will happend?

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'

6 Replies
Peter_Cammaert
Partner
Partner

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

marcus_malinow
Specialist III
Specialist III

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

ashwanin
Specialist
Specialist

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

ThornOfCrowns
Specialist II
Specialist II

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

mjm
Employee
Employee

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

maxgro
MVP
MVP

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