QIX

Calculated value.

Is set to true if the value is a numeric.

Name of the alternate state. Default is current selections: $

List of the selections.

Identifier of the app.

Title of the app.

Path of the app.

Last reload time of the app.

Is set to true if the app is read-only.

Layout for NxMetaDef.

If true the app has section access configured.

Information about the list of dimensions.

Type of the app list.

Contains dynamic JSON data specified by the client.

Script text.

Layout for NxMetaDef.

Pair of fields. < FieldName1> / < FieldName2> Where: < FieldName1 > is a field in the table 1 (defined in qTable1 ) < FieldName2 > is a field in the table 2 (defined in qTable2 ) If the field is a synthetic key, the name of the field is preceded by [Synthetic key]: .

Flag used to interpret calculated scores. One of the following values or sum of values that apply:

• 0: The cardinal ratio cannot be zero but the symbol score and the row score can be zero.
• -1: The fields do not have the same type.
• -2: The number of rows of the field FieldName1 is zero.
• -4: The number of distinct values of the field FieldName1 is zero.
• -8: The number of rows of the field FieldName2 is zero.
• -16: The number of distinct values of the field FieldName2 is zero.

Example: The number of rows of the field FieldName1 is zero, and the number of distinct values of the field FieldName2 is zero, then qScoreSummary is -18.

Array of token references that all together build up the definition of the current token. Generally, if the array is not empty, the definition is a BNF rule (qIsBnfRule is set to true). However, some BNF  rules do have an empty array (qIsBnfRule is set to true, but qBnf is empty).

Number of the current token definition.

Number of the parent rule definition.

Reference identifier to a function described in the documentation. The identifier is stored in the definition of the token containing the function name. Is not used in Qlik Sense.

Token name. One of:

• A rule name
• An identifier
• A literal value

Literal string of the token. Examples: 'Round' and '('.

If set to true, a list of related rule tokens is assigned to qBnf . This parameter is optional. The default value is false.

If set to true, the definition specifies a script statement. This parameter is optional. The default value is false.

If set to true, the definition specifies a control statement. This parameter is optional. The default value is false.

If set to true, the definition specifies a literal token. This parameter is optional. The default value is false.

If set to true, the definition is related to a Qlik Sense function. It cannot be an aggregation function. This parameter is optional. The default value is false.

If set to true, the definition is related to an aggregation function. This parameter is optional. The default value is false.

If set to true, the definition is related to a field. This parameter is optional. The default value is false.

Indicates whether a script statement, a chart or a script function is deprecated (not recommended for use). If set to true, the script statement or the function is not recommended for use in Qlik Sense. This parameter is optional. The default value is false.

List of groups the function belongs to.

NOT_META

META_DOC_NAME

META_RET_TYPE

META_DEFAULT_VALUE

SCRIPT_TEXT_SCRIPT

SCRIPT_TEXT_EXPRESSION

Indicates if the field is locked. Default is false.

List of excluded values. Either the list of selected values or the list of excluded values is displayed.

If set to true, selections within a list object are made in AND mode; If you have a list object that lists all customers, by selecting Customer 1 and Customer 2 while in and-mode, all records that are associated with Customer 1 and Customer 2 are selected. The default value is false; selections within a list object are made in OR mode. If you have a list object that lists all customers, by selecting Customer 1 and Customer 2 while in or-mode, all records that are associated with either Customer 1 or Customer 2 are selected. This parameter is not returned if set to false.

If set to true, the field has always one selection (not 0 and not more than 1). If another value is selected, the previous one is unselected. The default value is false. This parameter is not returned if set to false.

The start value of the range.

The end value of the range.

Information about the list of bookmarks.

Type of the list.

Contains dynamic JSON data specified by the client.

Include the bookmark patches. Patches can be very large and may make the list result unmanageable.

Name of the variable.

List of short day names.

List of short month names.

List of long day names.

List of long month names.

CHAR_ENCODING_UTF8

CHAR_ENCODING_UTF16

Position of the first search occurrence.

Number of occurrences found.

Information about the items in the app object.

Contains dynamic JSON data specified by the client.

Number of the code page.

Name of the code page.

Description of the code page.

Identifier of the connection. Is generated by the engine and is unique.

Name of the connection. This parameter is mandatory and must be set when creating or modifying a connection.

One of:

• ODBC CONNECT TO [<provider name>]
• OLEDB CONNECT TO [<provider name>]
• CUSTOM CONNECT TO [<provider name>]
• "<local absolute or relative path, UNC path>"
• "<URL>"

Connection string. This parameter is mandatory and must be set when creating or modifying a connection.

One of:

• ODBC
• OLEDB
• <Name of the custom connection file>
• folder
• internet

Type of the connection. This parameter is mandatory and must be set when creating or modifying a connection. For ODBC, OLEDB and custom connections, the engine checks that the connection type matches the connection string. The type is not case sensitive.

Name of the user who creates the connection. This parameter is optional; it is only used for OLEDB, ODBC and CUSTOM connections. A call to GetConnection Method does not return the user name.

Password of the user who creates the connection. This parameter is optional; it is only used for OLEDB, ODBC and CUSTOM connections. A call to GetConnection Method does not return the password.

Is generated by the engine. Creation date of the connection or last modification date of the connection.

Layout for NxMetaDef.

Information about the content library.

Name of the library.

Is set to true if the library is specific to the app (not a global content library).

Layout for NxMetaDef.

Name of the custom connector file.

Name of the parent folder that contains the custom connector file.

Name of the custom connector as displayed in the Qlik interface.

Name of the field.

Is set to true if the field is a primary key.

Is shown for fixed records. qOriginalFieldName and qName are identical if no field names are used in the file. qOriginalFieldName differs from qName if embedded file names are used in the file.

List of values inside the table. The first values (in result/qPreview/0/qValues ) correspond to the field names in the table. The following values (from result/qPreview/1/qValues ) are the values of the fields in the table.

Name of the table.

Type of the table. For example: Table or View.

Name of the table.

List of the fields in the table.

List of format specification items, within brackets. Examples of specification items:

• file type
• embedded labels, no labels
• table is <table name>

Name of the database.

Is set to true if the database is set by default.

Name of the product accessed by the provider.

If set to true, it means that the data source contains some databases.

If set to true, it means that the data source contains some owners.

Character string used after the database name. Example with separator " . ": FROM LinkedTablesData.dbo.Months Where:

• LinkedTablesData is the database name
• dbo is the owner name
• Months is the table name

Character string used after the owner name. Example with separator " . ": FROM LinkedTablesData.dbo.Months Where:

• LinkedTablesData is the database name
• dbo is the owner name
• Months is the table name

If set to true, it means that the database is displayed first, before the owners and tables.

Prefix used with field, database or owner names that contain special characters or keywords.

Suffix used with field, database or owner names that contain special characters or keywords.

List of the special characters.

Name of the default database.

List of the script keywords.

Name of the owner.

Name of the delimiter. Example: "Tab_DELIMITER"

Representation of the delimiter value that is used in the script. Example: "'\t'"

Delimiter character number used by the engine to determine how to separate the values.

Is set to true if multiple spaces are used to separate the values.

Name of the derived definition.

List of tags.

Is set to true is the derived field is in use.

Information about the list of dimensions.

Type of the list.

Contains dynamic JSON data specified by the client.

0: for default mode. 1: for ABEND; the reload of the script ends if an error occurs. 2: for ignore; the reload of the script continues even if an error is detected in the script.

Set to true for partial reload. The default value is false.

Set to true to debug reload. The default value is false.

Optional reload ID. ID will be automatically generated if not set.

The reload is successful if True.

Path to the script log file.

true if memory limits were exhausted during reload.

Name of the app.

Not used.

Last modified time stamp of the app. This property is used only with Qlik Sense Desktop. It is set to 0 for Qlik Sense Enterprise.

Size of remote app. This property is used only with Qlik Sense Desktop. It is set to 0 for Qlik Sense Enterprise.

Identifier of the app.

• In Qlik Sense Desktop, the identifier is the path and name of the app.
• In Qlik Sense Enterprise, the identifier is the app's GUID.

Layout for NxMetaDef.

Last reload time of the app.

If set to true, the app is read-only.

Title of the app.

If true the app has section access configured.

Is the app a Direct Query app?

Value of the drive. Examples: C:\, E:\\

Type of the drive. Fixed means physical drive.

Name of the drive.

Name of the breakpoint.

Line number in the script where the breakpoint is set.

If set to true then the breakpoint is enabled (in use).

Detailed information about the error message.

Line termination characters.

Script statement where the error occurs.

UNKNOWN

ASCII

INTEGER

REAL

FIX

MONEY

DATE

TIME

TIMESTAMP

INTERVAL

Number of decimals. Default is 10.

Defines whether or not a thousands separator must be used. Default is 0.

Defines the format pattern that applies to qText . Is used in connection to the type of the field (parameter qType ). For more information, see Formatting mechanism. Example: YYYY-MM-DD for a date.

Defines the decimal separator. Example: .

Defines the thousand separator (if any). Is used if qUseThou is set to 1. Example: ,

Name of the field.

Internal number of the field.

Name of the field.

List of table names.

If set to true, it means that the field is a system field. The default value is false.

If set to true, it means that the field is hidden. The default value is false.

If set to true, it means that the field is a semantic. The default value is false.

If set to true, only distinct field values are shown. The default value is false.

Number of distinct field values.

Total number of field values.

If set to true, it means that the field is locked. The default value is false.

If set to true, it means that the field has one and only one selection (not 0 and not more than 1). If this property is set to true, the field cannot be cleared anymore and no more selections can be performed in that field. The default value is false.

If set to true a logical AND (instead of a logical OR) is used when making selections in a field. The default value is false.

Is set to true if the value is a numeric. The default value is false.

Field comment.

Gives information on a field. For example, it can return the type of the field. Examples: key, text, ASCII.

If set to true, it means that the field is a field on the fly. The default value is false.

Static RAM memory used in bytes.

Name of the field.

Is shown for fixed records. qOriginalFieldName and qName are identical if no field names are used in the file. qOriginalFieldName differs from qName if embedded file names are used in the file.

This property is set to true if the field contains some Null values.

This property is set to true if the field contains some duplicate values.

This property is set to true if the field contains a synthetic key.

Number of records that have values (for example, not NULL) in the field as compared to the total number of records in the table.

Number of values that are non Null.

Number of rows in the field.

Number of distinct values in the field (in the current table) as compared to the total number of distinct values of this field (in all tables).

Number of distinct values in the field.

Comment related to the field.

List of tags related to the field.

List of the derived fields.

Name of the field.

List of tags related to the field.

Sets the formatting of a field. The properties of qFieldAttributes and the formatting mechanism are described below.

Formatting mechanism

The formatting mechanism depends on the type set in qType, as shown below:

Type is DATE, TIME, TIMESTAMP or INTERVAL

The following applies:

• If a format pattern is defined in qFmt , the formatting is as defined in qFmt .
• If qFmt is empty, the formatting is defined by the number interpretation variables included at the top of the script ( TimeFormat , DateFormat , TimeStampFormat ).
• The properties qDec , qThou , qnDec , qUseThou are not used.

Type is INTEGER

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the formatting mechanism uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , no formatting is applied. The properties qDec , qThou , qnDec , qUseThou and the number interpretation variables defined in the script are not used .

Type is REAL

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , and if the value is almost an integer value (for example, 14,000012), the value is formatted as an integer. The properties qDec , qThou , qnDec , qUseThou are not used.
• If no format pattern is defined in qFmt , and if qnDec is defined and not 0, the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.
• If no format pattern is defined in qFmt , and if qnDec is 0, the number of decimals is 14 and the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is FIX

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , the properties qDec and qnDec are used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is MONEY

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of any script ( MoneyDecimalSep and MoneyThousandSep ).
• If no format pattern is defined in qFmt , the engine uses the number interpretation variables included at the top of the script ( MoneyDecimalSep and MoneyThousandSep ).

Type is ASCII

No formatting, qFmt is ignored.

Number of distinct values

Number of distinct numeric values

Number of distinct text values

Number of numeric values

Number of null values

Number of textual values

Number of negative values

Number of positive values

Number of zero values for numerical values

Sum of all numerical values. NaN otherwise.

Squared sum of all numerical values. NaN otherwise.

Average of all numerical values. NaN otherwise.

Median of all numerical values. NaN otherwise.

Standard deviation of numerical values. NaN otherwise.

Minimum value of numerical values. NaN otherwise.

Maximum value of numerical values. NaN otherwise.

Skewness of the numerical values. NaN otherwise.

Kurtosis of the numerical values. NaN otherwise.

The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise.

Number of empty strings

Maximum string length of textual values. 0 otherwise.

Minimum string length of textual values. 0 otherwise.

Sum of all characters in strings in the field

Average string length of textual values. 0 otherwise.

For textual values the first sorted string.

For textual values the last sorted string.

Three most frequent values and their frequencies

Array of items.

Shows the system tables if set to true. Default is false.

Shows the hidden fields if set to true. Default is false.

Show the semantic fields if set to true. Default is false.

Shows the tables and fields present in the data model viewer if set to true. Default is false.

Shows the fields defined on the fly if set to true. Default is false.

Shows the fields and derived fields if set to true. Default is false.

Shows the Direct Discovery measure fields if set to true. Default is false.

Name of the field or column to be matched.

Name of the table to be matched on. This parameter is optional. If TableName is set, FieldName represent the Table column with that name. If TableName is not set, FieldName represents the the field with that name.

Field name. One of the field names defined in qFieldPairName.

Cardinality of a column/field divided by the number of rows in the table. If the cardinal ratio is 1, it means that the column is a candidate/primary key.

Number of distinct matches between the two fields defined in qFieldPairName divided by the number of distinct values in the field qFieldName . If 0, it means that there are no common values between the two fields defined in qFieldPairName .

Number of matches between the two fields defined in qFieldPairName divided by the number of values in the field qFieldName . If 0, it means that there are no common values between the two fields defined in qFieldPairName .

Text related to the field value. This parameter is optional.

Is set to true if the value is a numeric. This parameter is optional. Default is false.

Numeric value of the field. This parameter is displayed if qIsNumeric is set to true. This parameter is optional.

One of:

• Embedded labels (field names are present in the file)
• No labels
• Explicit labels (for DIFfiles)

One of:

• None (no quotes)
• MSQ (Modern Style Quoting)
• Standard (quotes " " or ' ' can be used, but only if they are the first and last non blank characters of a field value)

This property is used for delimited files.

String that marks the beginning of the comment line. Example: “#” or “//” The engine ignores the commented lines during the data load. This property is only used for delimited files.

Character set used in the file.

Size of the header. Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names.

Record length. Each record (row of data) contains a number of columns with a fixed field size. This property is used for fixed record data files.

Number of spaces that one tab character represents in the table file. This property is used for fixed record data files.

Is set to true, the end-of-file character is not taken into account during reload. This property is used for delimited files and fixed record data files.

Positions of the field breaks in the table. This property is used for fixed record data files.

FILE_TYPE_CSV

FILE_TYPE_FIX

FILE_TYPE_DIF

FILE_TYPE_EXCEL_BIFF

FILE_TYPE_EXCEL_OOXML

FILE_TYPE_HTML

FILE_TYPE_QVD

FILE_TYPE_XML

FILE_TYPE_QVX

FILE_TYPE_JSON

FILE_TYPE_KML

FILE_TYPE_PARQUET

FILTER_TYPE_NONE

FILTER_TYPE_RAW

Name of the folder item.

FOLDER_ITEM_FOLDER

FOLDER_ITEM_FILE

FOLDER_ITEM_OTHER

Number of bins.

Bins edges.

Bins frequencies.

Name of the script function.

Signature of the script function. Gives general information about the function.

FUNC_GROUP_ALL

FUNC_GROUP_UNKNOWN

FUNC_GROUP_NONE

FUNC_GROUP_AGGR

FUNC_GROUP_NUMERIC

FUNC_GROUP_RANGE

FUNC_GROUP_EXPONENTIAL_AND_LOGARITHMIC

FUNC_GROUP_TRIGONOMETRIC_AND_HYPERBOLIC

FUNC_GROUP_FINANCIAL

FUNC_GROUP_MATH_CONSTANT_AND_PARAM_FREE

FUNC_GROUP_COUNTER

FUNC_GROUP_STRING

FUNC_GROUP_MAPPING

FUNC_GROUP_INTER_RECORD

FUNC_GROUP_CONDITIONAL

FUNC_GROUP_LOGICAL

FUNC_GROUP_NULL

FUNC_GROUP_SYSTEM

FUNC_GROUP_FILE

FUNC_GROUP_TABLE

FUNC_GROUP_DATE_AND_TIME

FUNC_GROUP_NUMBER_INTERPRET

FUNC_GROUP_FORMATTING

FUNC_GROUP_COLOR

FUNC_GROUP_RANKING

FUNC_GROUP_GEO

FUNC_GROUP_EXTERNAL

FUNC_GROUP_PROBABILITY

FUNC_GROUP_ARRAY

FUNC_GROUP_LEGACY

FUNC_GROUP_DB_NATIVE

Layout for NxMetaDef.

Information about the field selections associated with the bookmark.

Used to collect meta data.

Properties

Semantic type with an empty structure.

If true all variables will be stored in the bookmark.

If true all selected values will be stored distinct, i.e. searchstrings will not be kept.

Length of the longest value in the field.

Number of distinct field values

Gives information on a field. For example, it can return the type of the field. Examples: key, text, ASCII

If set to true, it means that the field is a semantic.

If set to true a logical AND (instead of a logical OR) is used when making selections in a field. The default value is false.

Layout for NxMetaDef.

Cardinal and tags related to the dimension. Length of the longest value in the field.

Used to collect meta data.

Properties

Semantic type with an empty structure.

Information about the library measure. Is the layout for NxLibraryMeasureDef.

Layout for NxMetaDef.

Used to collect meta data.

Properties

Semantic type with an empty structure.

Information about the children of the generic object.

Layout for NxMetaDef.

Should be set to create an object that is linked to another object. Enter the identifier of the object you want to link to. If you do not want to link your object, set this parameter to an empty string.

Is set to true if the generic object contains some properties that are not persistent (a soft patch was applied).

Name of the alternate state. Default is current selections $ .

Should be set to create an object that is linked to another object. Enter the identifier of the linking object (i.e the object you want to link to). If you do not want to link your object, set this parameter to an empty string.

Used to collect meta data.

Properties

Semantic type with an empty structure.

Name of the alternate state. Default is current selections $ .

Layout for NxMetaDef.

Some text.

A value.

If set to true, it means that the variable was defined via script.

Used to collect meta data.

Properties

Semantic type with an empty structure.

Name of the variable. The name must be unique. This parameter is mandatory.

Comment related to the variable. This parameter is optional.

Sets the formatting of a field. The properties of qFieldAttributes and the formatting mechanism are described below.

Formatting mechanism

The formatting mechanism depends on the type set in qType, as shown below:

Type is DATE, TIME, TIMESTAMP or INTERVAL

The following applies:

• If a format pattern is defined in qFmt , the formatting is as defined in qFmt .
• If qFmt is empty, the formatting is defined by the number interpretation variables included at the top of the script ( TimeFormat , DateFormat , TimeStampFormat ).
• The properties qDec , qThou , qnDec , qUseThou are not used.

Type is INTEGER

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the formatting mechanism uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , no formatting is applied. The properties qDec , qThou , qnDec , qUseThou and the number interpretation variables defined in the script are not used .

Type is REAL

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , and if the value is almost an integer value (for example, 14,000012), the value is formatted as an integer. The properties qDec , qThou , qnDec , qUseThou are not used.
• If no format pattern is defined in qFmt , and if qnDec is defined and not 0, the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.
• If no format pattern is defined in qFmt , and if qnDec is 0, the number of decimals is 14 and the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is FIX

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , the properties qDec and qnDec are used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is MONEY

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of any script ( MoneyDecimalSep and MoneyThousandSep ).
• If no format pattern is defined in qFmt , the engine uses the number interpretation variables included at the top of the script ( MoneyDecimalSep and MoneyThousandSep ).

Type is ASCII

No formatting, qFmt is ignored.

Set this property to true to update the variable when applying a bookmark. The variable value will be persisted in the bookmark. The value of a variable can affect the state of the selections. Script variables cannot be persisted in the bookmark. The default value is false.

Definition of the variable.

Name of the alternate state. Default is current selections $ .

Information on the dimension.

Information on the measure.

Sort order of the columns in the hypercube. Column numbers are separated by a comma. Example: [1,0,2] means that the first column to be sorted was the column 1, followed by the column 0 and the column 2.

Aggregate for measures of all values in the field. The result value depends on the qAggrFunc defined in HyperCubeDef.

Set of data. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef.

Set of data for pivot tables. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef.

Set of data for stacked tables. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef.

Number of left dimensions. Default value is -1. The index related to each left dimension depends on the position of the pseudo dimension (if any). For example, a pivot table with:

• Four dimensions in the following order: Country, City, Product and Category
• One pseudo dimension in position 1
• Three left dimensions.

implies that:

• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the pseudo dimension.
• The index 2 corresponds to the left dimension City.
• Product and Category are top dimensions.

Another example:

• Four dimensions in the following order: Country, City, Product and Category.
• One pseudo dimension in position -1.
• Three left dimensions.

implies that:

• The index -1 corresponds to the pseudo dimension; the pseudo dimension is the most to the right.
• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the left dimension City.
• The index 2 corresponds to the left dimension Product.
• Category is a top dimension.

Is used for pivot tables only. If set to true, the formatting of the results is slightly different. This property is optional.

True if other row exists.

Title of the hypercube, for example the title of a chart.

The total number of nodes on each dimension (only applicable when qMode = T ).

The message displayed if calculation condition is not fulfilled.

The order of the columns.

Name of the alternate state. Default is current selections $ .

Array of dimensions.

Array of measures.

Defines the sort order of the columns in the hypercube. Column numbers are separated by a comma. Example: [1,0,2] means that the first column to be sorted should be the column 1, followed by the column 0 and the column 2. The default sort order is the order in which the dimensions and measures have been defined in the hypercube. By default, the pseudo-dimension (if any) is the most to the right in the array. The index of the pseudo-dimension (if any) is -1. Pseudo dimensions only apply for pivot tables with more than one measure. A pseudo dimension groups together the measures defined in a pivot table. You can neither collapse/expand a pseudo dimension nor make any selections in it. Stacked pivot tables can only contain one measure.

Removes zero values.

Removes missing values.

Initial data set.

Number of left dimensions. Default value is -1. In that case, all dimensions are left dimensions. Hidden dimensions (e.g. due to unfulfilled calc condition on dimension level) is still counted in this context. The index related to each left dimension depends on the position of the pseudo dimension (if any). For example, a pivot table with:

• Four dimensions in the following order: Country, City, Product and Category.
• One pseudo dimension in position 1 (the position is defined in qInterColumnSortOrder ) qInterColumnSortOrder is (0,-1,1,2,3).
• Three left dimensions ( qNoOfLeftDims is set to 3).

implies that:

• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the pseudo dimension.
• The index 2 corresponds to the left dimension City.
• Product and Category are top dimensions.

Another example:

• Four dimensions in the following order: Country, City, Product and Category.
• Three left dimensions ( qNoOfLeftDims is set to 3).
• One pseudo dimension.
• The property qInterColumnSortOrder is left empty.

Implies that:

• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the left dimension City.
• The index 2 corresponds to the left dimension Product.
• Category is a top dimension.
• The pseudo dimension is a top dimension.

If this property is set to true, the cells are always expanded. It implies that it is not possible to collapse any cells. The default value is false.

Maximum number of cells for an initial data fetch (set in qInitialDataFetch ) when in stacked mode ( qMode is K). The default value is 5000.

If this property is set to true, the missing symbols (if any) are replaced by 0 if the value is a numeric and by an empty string if the value is a string. The default value is false.

If set to true, the total (if any) is shown on the first row. The default value is false.

This property applies for pivot tables and allows to change the layout of the table. An indentation is added to the beginning of each row. The default value is false.

To enable the sorting by ascending or descending order in the values of a measure. This property applies to pivot tables and stacked pivot tables. In the case of a pivot table, the measure or pseudo dimension should be defined as a top dimension. The sorting is restricted to the values of the first measure in a pivot table.

The order of the columns.

Expansion state per dimension for pivot mode ( qMode is P).

Hypercube Modifier Dynamic script string

Set Expression valid for the whole cube. Used to limit computations to the set specified. *

Title used in the message box dialog. This property is relevant if qType is IT_MSGBOX.

Message used in the message box dialog. This property is relevant if qType is IT_MSGBOX.

Buttons displayed in the message box dialog. This property is relevant if qType is IT_MSGBOX. One of:

• 0 means that the qButtons property is not relevant.
• 17 means that the message box contains the OK and Cancel buttons or the stop -sign icon.

Next script statement to be executed. This property is used if the type of interaction is IT_SCRIPTLINE.

First line number of the previously executed statement. This property is used if the type of interaction is IT_SCRIPTLINE.

First line number of the next statement to be executed. This property is used if the type of interaction is IT_SCRIPTLINE.

Path specified by the Include script variable. This property is used if the type of interaction is IT_SCRIPTLINE. Example of an Include variable: $(Include=lib:\\MyDataFiles\abc.txt);

This property is set to true if the returned statement is an hidden script statement.

Not relevant for describing the requested user interaction.

Is not used in Qlik Sense.

The name of the field.

Number of selected values in the field.

Number of excluded values in the field.

A string indicating the origin of the data:

• [filename]: the data comes from a local file.
• INLINE: the data is entered inline in the load script.
• RESIDENT: the data comes from a resident table. The table name is listed.
• AUTOGENERATE: the data is generated from the load script (no external table of data source).
• Provider: the data comes from a data connection. The connector source name is listed.
• [webfile]: the data comes from a web-based file.
• STORE: path to QVD or TXT file where data is stored.
• EXTENSION: the data comes from a Server Side Extension (SSE).

The LOAD and SELECT script statements from the data load script.

Name of the alternate state. Default is current selections $ .

Lists the expressions in the list object.

Set of data. Is empty if nothing has been defined in qInitialDataFetch in ListObjectDef.

Name of the alternate state. Default is current selections $ .

Refers to a dimension stored in the library.

If set to true, alternative values are allowed in qData . If set to false, no alternative values are displayed in qData . Values are excluded instead. The default value is false. Note that on the contrary, the qStateCounts parameter counts the excluded values as alternative values. This parameter is optional.

Fetches an initial data set.

Lists the expressions in the list object. This parameter is optional.

If set to true, reduces the set of states returned. Supported for Direct Query mode only. Default is false.

Decimal separator.

Thousand separator.

List separator.

Money decimal separator.

Money thousand separator.

Current year.

Money format. Example: #.##0,00 kr;-#.##0,00 kr

Time format. Example: hh:mm:ss

Date format. Example: YYYY-MM-DD

Time stamp format. Example: YYYY-MM-DD hh:mm:ss[.fff]

First day of the week, starting from 0. According to ISO 8601, Monday is the first day of the week.

• 0 = Monday
• 1 = Tuesday
• ...
• 6 = Sunday

If this property has not been set in a script, the returned value comes from the Windows operating system.

Is set to true if broken weeks are allowed in a year. According to ISO 8601, no broken weeks should be allowed. This property is not shown if set to false. If qBrokenWeeks is set to true, qReferenceDay is irrelevant. If this property has not been set in a script, the returned value comes from the Windows operating system.

Day in the year that is always in week 1. According to ISO 8601, January 4th should always be part of the first week of the year ( qReferenceDay =4). Recommended values are in the range 1 and 7. If this property has not been set in a script, the returned value comes from the Windows operating system. This property is not relevant if there are broken weeks in the year.

First month of the year, starting from 1. According to ISO 8601, January is the first month of the year.

• 1 = January
• 2 = February
• 12 = January

If this property has not been set in a script, the returned value comes from the Windows operating system.

Locale name (following language tagging convention RFC 4646): < language>-<REGION> Where:

• language is a lowercase ISO  639 language code
• REGION specifies an uppercase ISO 3166 country code.

If this property has not been set in a script, the returned value comes from the Windows operating system.

Number format. Example: 3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y

Information about the list of measures.

Type of the list.

Contains dynamic JSON data specified by the client.

Information about the list of media files. In Qlik Sense Desktop, the media files are retrieved from: %userprofile%\Documents\Qlik\Sense\Content\Default In Qlik Sense Enterprise, the media files are retrieved from: <installation_directory>\Qlik\Sense\Repository\Content\Default The default installation directory is ProgramData .

Relative path to the media file. The URL is static. Media files located:

• in the /content/default/ folder are outside the qvf file.
• in the /media/ folder are embedded in the qvf file.

Relative path to the media file. Media files located:

• in the /content/default/ folder are outside the qvf file.
• in the /media/ folder are embedded in the qvf file.

Title of the app.

In Qlik Sense Enterprise, this property corresponds to the app identifier (GUID). In Qlik Sense Desktop, this property corresponds to the full path of the app.

Date and time of the last reload of the app in ISO format.

Is set to true if the app has been updated since the last save.

Is set to true if a script is defined in the app.

Array of alternate states.

Layout for NxMetaDef.

Is set to true if the app contains data following a script reload.

If set to true, it means that the app is read-only.

If set to true, it means that the app was opened without loading its data.

If set to true, the app is a Session App, i.e. not persistent.

If set to true, the app is in BDI Direct Query Mode.

If set to true, the app is in Direct Query Mode.

Array of features not supported by the app.

App title.

Last reload time of the app.

Internal property reserved for app migration. Patch version of the app. Do not update.

Internal property reserved for app migration. The app is saved in this version of the product. Do not update.

If true the app has section access configured.

Expression or field name.

LibraryId for dimension.

If set to true, this attribute will not affect the number of rows in the cube.

Cardinality of the attribute expression.

The title for the attribute dimension.

The Locked value of the dimension.

True if this is a calculated dimension.

Definition of the attribute expression. Example: "Max(OrderID)"

Definition of the attribute expression stored in the library. Example: "MyGenericMeasure"

If set to true, this measure will not affect the number of rows in the cube.