Especificaciones de evaluación relacionadas con las dimensiones de la competencia profesional

System variables, some of which are system-defined, provide information about the system and the Qlik Sense app.

System variables overview

Some of the functions are described further after the overview. For those functions, you can click the function name in the syntax to immediately access the details for that specific function.

Floppy

Returns the drive letter of the first floppy drive found, normallya:. This is a system-defined variable.

Floppy

This variable is not supported in standard mode.

CD

Returns the drive letter of the first CD-ROM drive found. If no CD-ROM is found, thenc: is returned. This is a system-defined variable.

CD

This variable is not supported in standard mode.

Include

TheInclude/Must_Include variable specifies a file that contains text that should be included in the script and evaluated as script code. You can store parts of your script code in a separate text file and reuse it in several apps. This is a user-defined variable.

$(Include =filename)

$(Must_Include=filename) HidePrefix

All field names beginning with this text string will be hidden in the same manner as the system fields. This is a user-defined variable.

HidePrefix HideSuffix

All field names ending with this text string will be hidden in the same manner as the system fields. This is a user-defined variable.

HideSuffix QvPath

Returns the browse string to the Qlik Sense executable. This is a system-defined variable.

QvPath

This variable is not supported in standard mode.

QvRoot

Returns the root directory of the Qlik Sense executable. This is a system-defined variable.

QvRoot

This variable is not supported in standard mode.

QvWorkPath

Returns the browse string to the current Qlik Sense app. This is a system-defined variable.

QvWorkPath

This variable is not supported in standard mode.

QvWorkRoot

Returns the root directory of the current Qlik Sense app. This is a system-defined variable.

QvWorkRoot

This variable is not supported in standard mode.

StripComments

If this variable is set to 0, stripping of /*..*/ and // comments in the script will be inhibited. If this variable is not

defined, stripping of comments will always be performed.

StripComments Verbatim

Normally all field values are automatically stripped of leading and trailing blanks (ASCII 32) before being loaded into the Qlik Sense database. Setting this variable to 1 suspends the stripping of blanks. Tab (ASCII 9) and hard space (ANSI 160) characters are never stripped.

Verbatim OpenUrlTimeout

This variable defines the timeout in seconds that Qlik Sense should respect when getting data from URL sources (e.g. HTML pages). If omitted, the timeout is about 20 minutes.

OpenUrlTimeout WinPath

Returns the browse string to Windows. This is a system-defined variable.

WinPath

This variable is not supported in standard mode.

WinRoot

Returns the root directory of Windows. This is a system-defined variable.

WinRoot

This variable is not supported in standard mode.

CollationLocale

Specifies which locale to use for sort order and search matching. The value is the culture name of a locale, for example 'en-US'.This is a system-defined variable.

CollationLocale

HidePrefix

All field names beginning with this text string will be hidden in the same manner as the system fields. This is a user-defined variable.

Syntax:

HidePrefix Example:

set HidePrefix='_' ;

If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.

HideSuffix

All field names ending with this text string will be hidden in the same manner as the system fields. This is a user-defined variable.

Syntax:

HideSuffix Example:

set HideSuffix='%';

If this statement is used, the field names ending with a percentage sign will not be shown in the field name lists when the system fields are hidden.

Include

TheInclude/Must_Include variable specifies a file that contains text that should be included in the script and evaluated as script code. You can store parts of your script code in a separate text file and reuse it in several apps. This is a user-defined variable.

This variable supports only folder data connections in standard mode.

Syntax:

$(Include=filename)

$(Must_Include=filename)

There are two versions of the variable:

l Include does not generate an error if the file cannot be found, it will fail silently.

l Must_Include generates an error if the file cannot be found.

If you don't specify a path, the filename will be relative to the Qlik Sense app working directory. You can also specify an absolute file path, or a path to a lib:// folder connection.

The construction set Include =filename is not applicable.

Examples:

$(Must_Include=lib://MyDataFiles\abc.txt);

OpenUrlTimeout

This variable defines the timeout in seconds that Qlik Sense should respect when getting data from URL sources (e.g. HTML pages). If omitted, the timeout is about 20 minutes.

Syntax:

OpenUrlTimeout Example:

set OpenUrlTimeout=10

StripComments

If this variable is set to 0, stripping of /*..*/ and // comments in the script will be inhibited. If this variable is not defined, stripping of comments will always be performed.

Syntax:

StripComments

Certain database drivers use /*..*/ as optimization hints inSELECT statements. If this is the case, the comments should not be stripped before sending theSELECT statement to the database driver.

It is recommended that this variable be reset to 1 immediately after the statement(s) where it is needed.

Example:

set StripComments=0;

SQL SELECT * /* <optimization directive> */ FROM Table ; set StripComments=1;

Verbatim

Normally all field values are automatically stripped of leading and trailing blanks (ASCII 32) before being loaded into the Qlik Sense database. Setting this variable to 1 suspends the stripping of blanks. Tab (ASCII 9) and hard space (ANSI 160) characters are never stripped.

Syntax:

Verbatim Example:

set Verbatim = 1;