The when prefix and suffix is used for creating a conditional clause which determines whether a statement or exit clause should be executed or not. It may be seen as a compact alternative to the full if..end if statement.


(when condition statement | exitstatement when condition )


The statement or the exitstatement will only be executed if condition is evaluated to True.

The when prefix may be used on statements which already have one or several other statements, including additional when or unless prefixes.


Argument Description
condition A logical expression evaluating to True or False.
statement Any Qlik Sense script statement except control statements.
exitstatement An exit for, exit do or exit sub clause or an exit script statement.

Example 1:  

exit script when A=1;

Example 2:  

when A=1 LOAD * from myfile.csv;

Example 3:  

when A=1 unless B=2 drop table Tab1;

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?