Control statements

When modifying chart data, you use a sub-set of the Qlik Sense script which consists of a number of statements. A statement can be either a regular script statement or a script control statement.

Control statements are typically used for controlling the flow of the script execution. Each clause of a control statement must be kept inside one script line and may be terminated by semicolon or end-of-line.

Prefixes are never applied to control statements.

All script keywords can be typed with any combination of lower case and upper case characters.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

The call control statement calls a subroutine which must be defined by a previous sub statement.

Call name ( [ paramlist ])

The do..loop control statement is a script iteration construct which executes one or several statements until a logical condition is met.

do [ ( while | until ) condition ] [statements]
[exit do [ ( when | unless ) condition ] [statements]
loop [ ( while | until ) condition ]

The End script keyword is used to close If, Sub and Switch clauses.

The Exit script keyword is part of the Exit Script statement, but can also be used to exit Do, For or Sub clauses.

This control statement stops script execution. It may be inserted anywhere in the script.

exit-script[ (when | unless) condition ]

The for..next control statement is a script iteration construct with a counter. The statements inside the loop enclosed by for and next will be executed for each value of the counter variable between specified low and high limits.

For counter = expr1 to expr2 [ stepexpr3 ]

[statements]

[exit for [ ( when | unless ) condition ]

[statements]

Next [counter]

The for each..next control statement is a script iteration construct which executes one or several statements for each value in a comma separated list. The statements inside the loop enclosed by for and next will be executed for each value of the list.

for-each var in list

[statements]

[exit for [ ( when | unless ) condition ]

[statements]

next [var]

The if..then control statement is a script selection construct forcing the script execution to follow different paths depending on one or several logical conditions.

Since the if..then statement is a control statement and as such is ended with either a semicolon or end-of-line, each of its four possible clauses (if..then, elseif..then, else and end if) must not cross a line boundary.

If condition then

[ statements ]

{ elseif condition then

[ statements ] }

[ else

[ statements ] ]

end if

The Next script keyword is used to close For loops.

The sub..end sub control statement defines a subroutine which can be called upon from a call statement.

Sub name [ ( paramlist )] statements end sub

The switch control statement is a script selection construct forcing the script execution to follow different paths, depending on the value of an expression.

Switch expression {case valuelist [ statements ]} [default statements] end switch

The To script keyword is used in several script statements.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here