Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use of variables ?

hi can i know what is the use of variables in qlikview , and how to use the variables ?

3 Replies
Anonymous
Not applicable
Author

Not applicable
Author

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.

rustyfishbones
Master II
Master II

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

2014-01-27_1537.png

You could change all the chart caption colors by changing just 1 variable!!

try it