Variables in QlikView
Variables are used to store static values or expressions. Variables make it easy to reuse expressions.
In QlikView, variables can be declared in the script or by invoking Variable Overview by pressing Ctrl + Alt +V. It can also be declared by navigating to Settings from menu and clicking on Variable Overview. Variables declared in the script can be seen in Variable Overview too.
In the script, variables are declared using Set and Let statements.
The Set statement assign literal strings to the variable, and the Let statement first evaluates the string and then assigns it to a variable:
Set vVariable1 = 1 + 3; //Value of vVariable1 is 1 + 3 Let vVariable2 = 1 + 3; //Value of vVariable2 is 4
It is important to discuss "dollar sign expansion" while discussing variables. Dollar sign expansions are definitions of text replacement. $(text) syntax expands the text that is between the $ sign and the parenthesis, and then it is evaluated. So an expression such as $(=1+3) will...
