Mastering Qlik Sense

Do... Loop

This control statement iterates one or more times until a condition is met. The condition is evaluated once the control statement and the code in it have been executed.

The syntax for Do... Loop is as follows:

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

Do... Loop has several constructions. The first one is driven by Do, which means a condition is evaluated before the code within Do... Loop is executed. For example:

LET vCount = 1;DO while vCount <= 5TRACE Loop will continue until variable vCount is less or equal to 5 $(vCount);LET vCount = $(vCount)+1;Loop;

In the previous example, the vCount <= 5 condition is evaluated before the first ...