The 'Force' Regular Statement

This article will cover the syntax of the ‘force’ regular script statement.

The force statement is used to force Qlik Sense to read subsequently specified field names in a specific case such as upper case, lower case and capitalised. This can be useful for associating tables on fields with the same name but in a different case.

Statement syntax

Copy code


Force capitalization | case upper | case lower | case mixed;

capitalization | case upper | case lower | case mixed

Here is where you specify how Qlik Sense should read the field names.

Example

We load two tables that are to be associated on the fields ‘itemID’. The field is in different cases in the tables. By using force with case upper, Qlik Sense will change the case of all field names to be upper and thus associate the tables correctly.

Copy code


Force case upper;
ORDER_ITEMS:
load * inline [
  orderID, itemId
  1,1
];
ITEM_DETAILS:
load * inline [
  itemID, cost, type, flavour
  1,0.50,ice cream, strawberry
];