Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi can i know what is the use of variables in qlikview , and how to use the variables ?
With variables in QlikView you can do data transformations and calculations.
‘LET’ and ‘SET’ are used for defining Variables in the script. The variables can be used for substituting strings, paths, drives, etc.
‘SET’ treats everything after the equal sign (=) as String. If it contains space, then you need double quote in the beginning and the end.
Ex: Set Constant="My string";
‘LET’ evaluates the expression after the equal sign (=) and stores the value.
Ex: Let Date=Today();
Output would be today's date.
Hi,
Variables are particularly powerful if you want to change the visual look of a DashBoard Quickly
Create a Variable and call it color.main.1
SET color.main.1 = RGB(0,128,0)
then if you are using this color for chart captions like
You could change all the chart caption colors by changing just 1 variable!!
try it