Force

The force statement forces Qlik Sense to interpret field values of subsequent LOAD and SELECT statements as written with only upper case letters, with only lower case letters, as always capitalized or as they appear (mixed). This statement makes it possible to associate field values from tables made according to different conventions.

Syntax:  

Force ( capitalization | case upper | case lower | case mixed )

 

If nothing is specified, force case mixed is assumed. The force statement is valid until a new force statement is made.

The force statement has no effect in the access section: all field values loaded are case insensitive.

Examples:  

Force Capitalization;

Force Case Upper;

Force Case Lower;

Force Case Mixed;