Skip to main content Skip to complementary content

Do..loop

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

Syntax:  

Do [ ( while | until ) condition ] [statements]

[exit do [ ( when | unless ) condition ] [statements]

loop[ ( while | until ) condition ]

 

Information noteSince the do..loop statement is a control statement and as such is ended with either a semicolon or end-of-line, each of its three possible clauses (do, exit do and loop) must not cross a line boundary.

Arguments:  

Do arguments
Argument Description
condition

A logical expression evaluating to True or False.

statements

Any group of one or more QlikView script statements.

while / until

The while or until conditional clause must only appear once in any do..loop statement, i.e. either after do or after loop. Each condition is interpreted only the first time it is encountered but is evaluated for every time it encountered in the loop.

exit do

If an exit do clause is encountered inside the loop, the execution of the script will be transferred to the first statement after the loop clause denoting the end of the loop. An exit do clause can be made conditional by the optional use of a when or unless suffix.

Example:  

// LOAD files file1.csv..file9.csv

Set a=1;

Do while a<10

LOAD * from file$(a).csv;

Let a=a+1;

Loop

Learn more

 

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com