Force

The force statement forces QlikView to interpret field names and 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.

 

Example Result

This example shows how to force capitalization.

FORCE Capitalization;

Capitalization:

LOAD * Inline [

ab

Cd

eF

GH

];

The Capitalization table contains the following values:

Ab

Cd

Ef

Gh

All values are capitalized.

This example shows how to force case upper.

FORCE Case Upper;

CaseUpper:

LOAD * Inline [

ab

Cd

eF

GH

];

The CaseUpper table contains the following values:

AB

CD

EF

GH

All values are upper case.

This example shows how to force case lower.

FORCE Case Lower;

CaseLower:

LOAD * Inline [

ab

Cd

eF

GH

];

The CaseLower table contains the following values:

ab

cd

ef

gh

All values are lower case.

This example shows how to force case mixed.

FORCE Case Mixed;

CaseMixed:

LOAD * Inline [

ab

Cd

eF

GH

];

The CaseMixed table contains the following values:

ab

Cd

eF

GH

All values are as they appear in the script.

See also:

 

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?