QIX

v12.1394.0

The JSON-RPC API over websocket that enables you to interact with the Qlik Associative Engine.

The QIX API is the primary API used for working with Qlik apps. It's based on the WebSocket protocol and requires some specific parameters to work correctly as seen below.

WebSockets

When you want to use the API, any websocket client implementation that follows the RFC specification should be supported. The URL format is:

wss://your-tenant.us.qlikcloud.com/app/<app id>

Browser example:

const websocket = new WebSocket('wss://your-tenant.us.qlikcloud.com/app/123e4567-e89b-12d3-a456-426655440000');

Headers

In a non-browser environment, most websocket client implementations support to add headers.

Use header Authorization: Bearer <token> with API key for authentication.

Session sharing

When using the QIX API you build up a state in what's called a session. A session is based on a tenant, a user, and the app. When opening a new websocket you'd either get a new unique session, or get attached to an existing session. When sharing a session, the state (like selections), is shared between all websocket connections.

The conditions for sharing a session is:

  • The websocket URL needs to be identical (tenant URL and app id)
  • The user needs to be the same:
    • in a browser environment the same user needs to be signed in
    • in a non-browser environment an API key from the same user and tenant needs to be used

JSON-RPC protocol

The QIX API leverages the JSON-RPC protocol. It implements a superset of this specification. All requests sent from the client should contain the following properties:

{
  // Protocol descriptor:
  "jsonrpc": "2.0",
  // Session-unique numeric id, referred to in the response
  // to connect the request and response:
  "id": 6,
  // The handle for the object to interact with:
  "handle": 2,
  // The object type of the handle above decides
  // which API methods you may invoke:
  "method": "ApiMethodName",
  // Parameters for the invoked API method:
  "params": {}
}

Request and response

Here is an example request/response pair. Note that there is only one static handle in the QIX API, and that's -1. This handle refers to the Global API.

In this example request, an app is opened using OpenDoc. If successful, the response contains a reference to the app handle, which can be used to do further requests towards the Doc (app) API, and so forth.

{
  "jsonrpc": "2.0",
  "id": 1,
  "handle": -1,
  "method": "OpenDoc",
  "params": {
    "qDocName": "<app id>"
  }
}

If that app exist, the response would look similar to this:

{
  "jsonrpc": "2.0",
  "id": 1,
  "result": {
    "qReturn": {
      "qType": "Doc",
      "qHandle": 1,
      "qGenericId": "<app id>"
    }
  },
  "change": [1]
}

Note that qHandle contains the handle that might be used to make additional requests to invoke API methods towards the app. A property called change is also received on the response, an array that can be sent by QIX Engine on any responses and contains all open handles in your session that may have been invalidated and you should refetch data to ensure your application in a valid state.

Session apps

Session apps are non-persisted Qlik Sense apps created on-the-fly in server memory by the Qlik Associative Engine. You have to define a load script and trigger a data reload before any data model is accessible for each user session. Similarly, if you create a session app from an existing app, you have to trigger a reload after retrieving objects from the template app.

Session apps are attached to the active Qlik Associative Engine session. When a session ends, for example, by the user logging out, the session app is terminated and all related resources are released from server memory. Standard Qlik security rules ensure that only authenticated users can access data and visualizations from a session app.

WebSocket URL for session apps

The WebSocket URL for creating a session app has the following format:

wss://my-tenant.us.qlikcloud.com/app/SessionApp_{appId}

You must append a unique app ID to SessionApp_ in the path. The app ID can be a code-generated random number.

To create a session app from an app, you must add the template app ID as a query parameter to the URL:

wss://my-tenant.us.qlikcloud.com/app/SessionApp_{appId}?from={templateAppId}

Error Handling

When something happens unexpectedly, the WebSocket may be closed with an error code and message. The error code will be a 4-digit number and the message may or may not be empty. The code below should be used for monitoring this.

ws.on("close", (code, message) => {
    console.log(code);
    console.log(String(message));
});
4204
{"code":"QEP-104","traceId":"491a33e544de8dda40a9fc9b0cb53216"}

The following is a list of error codes and their causes:

  • 4202 - the WebSocket request appears to be malformed
  • 4203 - the request could not be fulfilled because of a permissions issue
  • 4204 - the request failed because something could not be found, this may be because the app id in the URL is wrong or the app has been deleted
  • 4205 - the request could not be fulfilled because the system is busy, consider sending the request again later

API references

For the API references, see the different classes listed in the left-side menu.

schemas

schemasAlfaNumString

object
deprecated

Properties

qString
string

Calculated value.

qIsNum
boolean

Is set to true if the value is a numeric.

schemasAlternateStateData

object

Properties

qStateName
string

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

qFieldItems

List of the selections.

schemasAppEntry

object

Properties

qID
string

Identifier of the app.

qTitle
string

Title of the app.

qPath
string

Path of the app.

qLastReloadTime
string

Last reload time of the app.

qReadOnly
boolean

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

qMeta

Layout for NxMetaDef.

qThumbnail
In addition, this structure can return dynamic properties.
qFileSize
integer<int64>

No description

qHasSectionAccess
boolean

If true the app has section access configured.

schemasAppObjectList

object

Lists the app objects. Is the layout for AppObjectListDef.

An app object is a generic object created at app level.

Properties

qItems

Information about the list of dimensions.

schemasAppObjectListDef

object

Defines the list of objects in an app.

An app object is a generic object created at app level.

Properties

qType
string

Type of the app list.

qData

Contains dynamic JSON data specified by the client.

schemasAppScript

object

Properties

qScript
string

Script text.

qMeta

Layout for NxMetaDef.

schemasArrayOfNxValuePoint

Array<NxPivotValuePoint>

schemasAssociationScore

object

Properties

qFieldPairName
string

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]: .

qScoreSummary
integer<int32>

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.

qField1Scores

No description

qField2Scores

No description

schemasBNFDef

object

Properties

qBnf
Array<integer<int32>>

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).

qNbr
integer<int32>

Number of the current token definition.

qPNbr
integer<int32>

Number of the parent rule definition.

qHelpId
integer<int32>

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.

qName
string

Token name. One of:

  • A rule name
  • An identifier
  • A literal value
qStr
string

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

qIsBnfRule
default=false
boolean

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

qScriptStatement
default=false
boolean

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

qControlStatement
default=false
boolean

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

qBnfLiteral
default=false
boolean

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

qQvFunc
default=false
boolean

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.

qAggrFunc
default=false
boolean

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

qFG

No description

qFieldFlag
default=false
boolean

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

qMT

No description

qDepr
default=false
boolean

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.

qFGList

List of groups the function belongs to.

schemasBNFDefMetaType

string

oneOf

N

NOT_META

D

META_DOC_NAME

R

META_RET_TYPE

V

META_DEFAULT_VALUE

schemasBNFType

string

oneOf

S

SCRIPT_TEXT_SCRIPT

E

SCRIPT_TEXT_EXPRESSION

schemasBlob

Array<integer<byte>>

schemasBookmark

object

Properties

qId
string

No description

qName
string

No description

qUtcModifyTime
number<double>

No description

qUtcRecallTime
number<double>

No description

qRecallCount
integer<int32>

No description

qApplyAdditive
boolean

No description

qFieldItems

No description

qVariableItems

No description

qSheetId
string

No description

qObjects

No description

qApplyLayoutState
default=false
boolean

No description

qShowPopupInfo
default=false
boolean

No description

qInfoText
string

No description

qOwner
string

No description

qGroups

No description

qShow

No description

qApplyInputFieldValues
default=true
boolean

No description

qInputFieldItems

No description

qObjectsLayout

No description

qIncludeSelectionState
default=true
boolean

No description

qIncludeScrollPosition
boolean

No description

qAlternateStateData

No description

qForAnnotations
boolean

No description

qIncludeAllVariables
default=false
boolean

No description

schemasBookmarkFieldItem

object

Properties

qDef

No description

qLocked
boolean

Indicates if the field is locked. Default is false.

qSelectInfo

No description

qValues

No description

qExcludedValues

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

qAndMode
boolean

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.

qOneAndOnlyOne
boolean

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.

schemasBookmarkFieldPage

object

Defines the range of the bookmark fields that are returned.

Properties

qStartIndex
integer<int32>

The start value of the range.

qEndIndex
integer<int32>

The end value of the range.

schemasBookmarkList

object

Lists the bookmarks. Is the layout for BookmarkListDef.

Properties

qItems

Information about the list of bookmarks.

schemasBookmarkListDef

object

Defines the list of bookmarks.

Properties

qType
string

Type of the list.

qData

Contains dynamic JSON data specified by the client.

qIncludePatches
boolean

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

schemasBookmarkVariableItem

object

Properties

qName
string

Name of the variable.

qValue

No description

schemasCalendarStrings

object

Properties

qDayNames
Array<string>

List of short day names.

qMonthNames
Array<string>

List of short month names.

qLongDayNames
Array<string>

List of long day names.

qLongMonthNames
Array<string>

List of long month names.

schemasCharEncodingType

string

oneOf

Utf8

CHAR_ENCODING_UTF8

Utf16

CHAR_ENCODING_UTF16

schemasCharRange

object

Properties

qCharPos
integer<int32>

Position of the first search occurrence.

qCharCount
integer<int32>

Number of occurrences found.

schemasChildList

object

Lists the children of a generic object. Is the layout for ChildListDef.

ChildList is used by the _GetLayout Method_ to list the children of a generic object.

Properties

qItems

Information about the items in the app object.

schemasChildListDef

object

Defines the list of children of a generic object. What is defined in ChildListDef has an impact on what the GetLayout method returns. See Example for more information.

Properties

qData

Contains dynamic JSON data specified by the client.

schemasCodePage

object

Properties

qNumber
integer<int32>

Number of the code page.

qName
string

Name of the code page.

qDescription
string

Description of the code page.

schemasCondDef

object

Properties

qAlways
default=true
boolean

No description

qExpression

No description

schemasConnection

object

Properties

qId
string

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

qName
string

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

qConnectionString
string

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.

qType
string

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.

qUserName
string

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.

qPassword
string

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.

qModifiedDate
string

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

qMeta

Layout for NxMetaDef.

qLogOn

No description

schemasContentLibraryList

object

Properties

qItems

Information about the content library.

schemasContentLibraryListItem

object

Properties

qName
string

Name of the library.

qAppSpecific
boolean

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

qMeta

Layout for NxMetaDef.

schemasCustomConnector

object

Properties

qProvider
string

Name of the custom connector file.

qParent
string

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

qDisplayName
string

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

qMachineMode

No description

qSupportFileStreaming
boolean

No description

schemasDataField

object

Properties

qName
string

Name of the field.

qIsKey
default=false
boolean

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

qOriginalFieldName
string

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.

schemasDataRecord

object

Properties

qValues
Array<string>

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.

schemasDataTable

object

Properties

qName
string

Name of the table.

qType
string

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

schemasDataTableEx

object

Properties

qName
string

Name of the table.

qFields

List of the fields in the table.

qFormatSpec
string

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

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

schemasDatabase

object

Properties

qName
string

Name of the database.

qIsDefault
boolean

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

schemasDatabaseInfo

object

Properties

qDBMSName
string

Name of the product accessed by the provider.

qDBUsage
boolean

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

qOwnerUsage
boolean

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

qDBSeparator
string

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
qOwnerSeparator
string

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
qDBFirst
boolean

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

qQuotePreffix
string

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

qQuoteSuffix
string

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

qSpecialChars
string

List of the special characters.

qDefaultDatabase
string

Name of the default database.

qKeywords
Array<string>

List of the script keywords.

schemasDatabaseOwner

object

Properties

qName
string

Name of the owner.

schemasDelimiterInfo

object

Properties

qName
string

Name of the delimiter. Example: "Tab_DELIMITER"

qScriptCode
string

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

qNumber
integer<int32>

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

qIsMultiple
boolean

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

schemasDerivedFieldsInTableData

object

Properties

qDefinitionName
string

Name of the derived definition.

qTags
Array<string>

List of tags.

qActive
boolean

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

schemasDimensionList

object

Lists the dimensions. Is the layout for DimensionListDef.

Properties

qItems

Information about the list of dimensions.

schemasDimensionListDef

object

Defines the lists of dimensions.

Properties

qType
string

Type of the list.

qData

Contains dynamic JSON data specified by the client.

schemasDoReloadExParams

object

Parameters for a reload.

Properties

qMode
default=0
integer<int32>

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.

qPartial
default=false
boolean

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

qDebug
default=false
boolean

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

qReloadId
string

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

schemasDoReloadExResult

object

The result and path to script log for a reload.

Properties

qSuccess
boolean

The reload is successful if True.

qScriptLogFile
string

Path to the script log file.

qEndedWithMemoryConstraint
boolean

true if memory limits were exhausted during reload.

schemasDocListEntry

object

Properties

qDocName
string

Name of the app.

qConnectedUsers
integer<int32>

Not used.

qFileTime
number<double>

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.

qFileSize
number<double>

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

qDocId
string

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.
qMeta

Layout for NxMetaDef.

qLastReloadTime
string

Last reload time of the app.

qReadOnly
boolean

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

qTitle
string

Title of the app.

qThumbnail
In addition, this structure can return dynamic properties.
qHasSectionAccess
boolean

If true the app has section access configured.

qIsDirectQueryMode
boolean

Is the app a Direct Query app?

schemasDriveInfo

object

Properties

qDrive
string

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

qType
string

Type of the drive. Fixed means physical drive.

qName
string

Name of the drive.

qTypeIdentifier

No description

qUnnamedDrive
boolean

No description

schemasDriveType

string

oneOf

REMOVABLE

No description

FIXED

No description

NETWORK

No description

CD_ROM

No description

RAM

No description

UNKNOWN_TYPE

No description

schemasEditorBreakpoint

object

Properties

qbufferName
string

Name of the breakpoint.

qlineIx
integer<int32>

Line number in the script where the breakpoint is set.

qEnabled
boolean

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

schemasEmbeddedSnapshot

object

Renders the embedded snapshot in an object. The following is returned:

  • Any dynamic properties defined in the bookmark
  • Any properties defined in qEmbeddedSnapshot

Properties

"qEmbeddedSnapshot": {}

schemasEmbeddedSnapshotDef

object

Defines the embedded snapshot in a generic object.

Properties

"EmbeddedSnapshotDef": {}

schemasErrorData

object

Properties

qErrorString
string

Detailed information about the error message.

qLineEnd
string

Line termination characters.

qLine
string

Script statement where the error occurs.

qErrorDataCode

No description

qMessage

No description

schemasErrorDataCode

string

oneOf

EDC_ERROR

No description

EDC_WARNING

No description

EDC_CIRCULAR_REFERENCE

No description

schemasExpansionData

object

Properties

qExcludeList
boolean

No description

qPos

No description

schemasExtendedLayoutBookmarkData

object

Properties

qId
string

No description

qActive
boolean

No description

qShowMode
integer<byte>

No description

qScrollPos

No description

qExpansionInfo

No description

qLeftCollapsed
boolean

No description

qTopCollapsed
boolean

No description

qSortData

No description

qDimensionGroupPos

No description

qExpressionGroupPos

No description

qUseGraphMode
boolean

No description

qGraphMode

No description

qActiveContainerChildObjectId
string

No description

qExtendedPivotState

No description

schemasExtendedPivotStateData

object

Properties

qExpressionPosition
integer<byte>

No description

qNumberOfLeftDimensions
integer<byte>

No description

qDimensionNames
Array<string>

No description

qEnableConditions
Array<string>

No description

schemasExtensionList

object

Obsolete, use qrs API's to fetch extensions.

Properties

qItems
Array<string>

No description

schemasExtensionListDef

object

Obsolete, use qrs API's to fetch extensions.

schemasFieldAttrType

string

oneOf

U

UNKNOWN

A

ASCII

I

INTEGER

R

REAL

F

FIX

M

MONEY

D

DATE

T

TIME

TS

TIMESTAMP

IV

INTERVAL

schemasFieldAttributes

object

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

Properties

qType

No description

qnDec
default=10
integer<int32>

Number of decimals. Default is 10.

qUseThou
default=0
integer<int32>

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

qFmt
string

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.

qDec
string

Defines the decimal separator. Example: .

qThou
string

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

schemasFieldDefEx

object

Properties

qName
string

Name of the field.

qType

No description

schemasFieldDescription

object

Properties

qInternalNumber
integer<int32>

Internal number of the field.

qName
string

Name of the field.

qSrcTables
Array<string>

List of table names.

qIsSystem
boolean

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

qIsHidden
boolean

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

qIsSemantic
boolean

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

qDistinctOnly
boolean

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

qCardinal
integer<int32>

Number of distinct field values.

qTotalCount
integer<int64>

Total number of field values.

qPossibleCount_OBSOLETE
integer<int32>

No description

qHasInfo_OBSOLETE
boolean

No description

qIsLocked
boolean

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

qAlwaysOneSelected
boolean

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.

qAndMode
boolean

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.

qIsNumeric
boolean

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

qComment
string

Field comment.

qTags
Array<string>

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

qIsDefinitionOnly
boolean

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

qByteSize
integer<int64>

Static RAM memory used in bytes.

schemasFieldInTableData

object

Properties

qName
string

Name of the field.

qOriginalFields
Array<string>

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.

qPresent
boolean

No description

qHasNull
boolean

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

qHasWild
boolean

No description

qHasDuplicates
boolean

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

qIsSynthetic
boolean

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

qInformationDensity
number<double>

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

qnNonNulls
integer<int64>

Number of values that are non Null.

qnRows
integer<int64>

Number of rows in the field.

qSubsetRatio
number<double>

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).

qnTotalDistinctValues
integer<int32>

Number of distinct values in the field.

qnPresentDistinctValues
integer<int32>

No description

qKeyType

No description

qComment
string

Comment related to the field.

qTags
Array<string>

List of tags related to the field.

qDerivedFields

List of the derived fields.

qIsFieldOnTheFly
default=false
boolean

No description

qReadableName
string

No description

schemasFieldInTableProfilingData

object

Properties

qName
string

Name of the field.

qFieldTags
Array<string>

List of tags related to the field.

qNumberFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qDistinctValues
integer<int64>

Number of distinct values

qDistinctNumericValues
integer<int64>

Number of distinct numeric values

qDistinctTextValues
integer<int64>

Number of distinct text values

qNumericValues
integer<int64>

Number of numeric values

qNullValues
integer<int64>

Number of null values

qTextValues
integer<int64>

Number of textual values

qNegValues
integer<int64>

Number of negative values

qPosValues
integer<int64>

Number of positive values

qZeroValues
integer<int64>

Number of zero values for numerical values

qSum
number<double>

Sum of all numerical values. NaN otherwise.

qSum2
number<double>

Squared sum of all numerical values. NaN otherwise.

qAverage
number<double>

Average of all numerical values. NaN otherwise.

qMedian
number<double>

Median of all numerical values. NaN otherwise.

qStd
number<double>

Standard deviation of numerical values. NaN otherwise.

qMin
number<double>

Minimum value of numerical values. NaN otherwise.

qMax
number<double>

Maximum value of numerical values. NaN otherwise.

qSkewness
number<double>

Skewness of the numerical values. NaN otherwise.

qKurtosis
number<double>

Kurtosis of the numerical values. NaN otherwise.

qFractiles
Array<number<double>>

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

qEmptyStrings
integer<int64>

Number of empty strings

qMaxStringLen
integer<int64>

Maximum string length of textual values. 0 otherwise.

qMinStringLen
integer<int64>

Minimum string length of textual values. 0 otherwise.

qSumStringLen
integer<int64>

Sum of all characters in strings in the field

qAvgStringLen
number<double>

Average string length of textual values. 0 otherwise.

qFirstSorted
string

For textual values the first sorted string.

qLastSorted
string

For textual values the last sorted string.

qMostFrequent

Three most frequent values and their frequencies

qFrequencyDistribution

No description

schemasFieldList

object

Lists the fields present in the data model viewer. Is the layout for FieldListDef.

Properties

qItems

Array of items.

schemasFieldListDef

object

Defines the fields to show.

Properties

qShowSystem
default=false
boolean

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

qShowHidden
default=false
boolean

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

qShowSemantic
default=false
boolean

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

qShowSrcTables
default=false
boolean

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

qShowDefinitionOnly
default=false
boolean

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

qShowDerivedFields
default=false
boolean

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

qShowImplicit
default=false
boolean

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

schemasFieldOrColumn

object

Properties

qFieldName
string

Name of the field or column to be matched.

qTableName
string

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.

schemasFieldScores

object

Properties

qFieldName
string

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

qReadableName
string

No description

qCardinalRatio
number<double>

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.

qSymbolScore
number<double>

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 .

qRowScore
number<double>

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 .

schemasFieldType

string

oneOf

NOT_PRESENT

No description

PRESENT

No description

IS_CYCLIC_GROUP

No description

IS_DRILL_GROUP

No description

IS_VAR

No description

IS_EXPR

No description

IS_IMPLICIT

No description

IS_DETAIL

No description

schemasFieldValue

object

Properties

qText
string

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

qIsNumeric
boolean

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

qNumber
number<double>

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

schemasFileDataFormat

object

FileType

Recognized file formats are:

  • CSV for Delimited
  • FIX for Fixed Record
  • DIF for Data Interchange Format
  • EXCEL_BIFF for Microsoft Excel (XLS)
  • EXCEL_OOXML for Microsoft Excel (XLSX)
  • HTML for HTML
  • QVD for QVD file
  • XML for XML
  • QVX for QVX file
  • JSON for JSON format
  • KML for KML file
  • PARQUET for PARQUET file

Properties

qType

No description

qLabel
string

One of:

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

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.

qComment
string

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.

qDelimiter

No description

qCodePage
integer<int32>

Character set used in the file.

qHeaderSize
integer<int32>

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.

qRecordSize
integer<int32>

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.

qTabSize
integer<int32>

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

qIgnoreEOF
boolean

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.

qFixedWidthDelimiters
string

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

schemasFileType

string

oneOf

CSV

FILE_TYPE_CSV

FIX

FILE_TYPE_FIX

DIF

FILE_TYPE_DIF

EXCEL_BIFF

FILE_TYPE_EXCEL_BIFF

EXCEL_OOXML

FILE_TYPE_EXCEL_OOXML

HTML

FILE_TYPE_HTML

QVD

FILE_TYPE_QVD

XML

FILE_TYPE_XML

QVX

FILE_TYPE_QVX

JSON

FILE_TYPE_JSON

KML

FILE_TYPE_KML

PARQUET

FILE_TYPE_PARQUET

schemasFilterInfo

object

Properties

qType

No description

qWherePredicate
string

No description

schemasFilterType

string

oneOf

NONE

FILTER_TYPE_NONE

RAW

FILTER_TYPE_RAW

schemasFolderItem

object

Properties

qName
string

Name of the folder item.

qType

No description

schemasFolderItemType

string

oneOf

FOLDER

FOLDER_ITEM_FOLDER

FILE

FOLDER_ITEM_FILE

OTHER

FOLDER_ITEM_OTHER

schemasFrequencyDistributionData

object

Properties

qNumberOfBins
integer<int32>

Number of bins.

qBinsEdges
Array<number<double>>

Bins edges.

qFrequencies
Array<integer<int32>>

Bins frequencies.

schemasFunction

object

Properties

qName
string

Name of the script function.

qGroup

No description

qSignature
string

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

schemasFunctionGroup

string

oneOf

ALL

FUNC_GROUP_ALL

U

FUNC_GROUP_UNKNOWN

NONE

FUNC_GROUP_NONE

AGGR

FUNC_GROUP_AGGR

NUM

FUNC_GROUP_NUMERIC

RNG

FUNC_GROUP_RANGE

EXP

FUNC_GROUP_EXPONENTIAL_AND_LOGARITHMIC

TRIG

FUNC_GROUP_TRIGONOMETRIC_AND_HYPERBOLIC

FIN

FUNC_GROUP_FINANCIAL

MATH

FUNC_GROUP_MATH_CONSTANT_AND_PARAM_FREE

COUNT

FUNC_GROUP_COUNTER

STR

FUNC_GROUP_STRING

MAPP

FUNC_GROUP_MAPPING

RCRD

FUNC_GROUP_INTER_RECORD

CND

FUNC_GROUP_CONDITIONAL

LOG

FUNC_GROUP_LOGICAL

NULL

FUNC_GROUP_NULL

SYS

FUNC_GROUP_SYSTEM

FILE

FUNC_GROUP_FILE

TBL

FUNC_GROUP_TABLE

DATE

FUNC_GROUP_DATE_AND_TIME

NUMI

FUNC_GROUP_NUMBER_INTERPRET

FRMT

FUNC_GROUP_FORMATTING

CLR

FUNC_GROUP_COLOR

RNK

FUNC_GROUP_RANKING

GEO

FUNC_GROUP_GEO

EXT

FUNC_GROUP_EXTERNAL

PROB

FUNC_GROUP_PROBABILITY

ARRAY

FUNC_GROUP_ARRAY

LEG

FUNC_GROUP_LEGACY

DB

FUNC_GROUP_DB_NATIVE

schemasGenericBookmarkEntry

object

Properties

qProperties

No description

qBookmark

No description

qClassicBookmark

No description

qClassicMetadata

No description

schemasGenericBookmarkLayout

object

Is the layout for GenericBookmarkProperties.

Properties

qInfo

No description

qMeta

Layout for NxMetaDef.

qBookmark

No description

qFieldInfos

Information about the field selections associated with the bookmark.

schemasGenericBookmarkProperties

object

Properties

qInfo

No description

qMetaDef

Used to collect meta data.

Properties

Semantic type with an empty structure.

qIncludeVariables
default=false
boolean

If true all variables will be stored in the bookmark.

qDistinctValues
default=false
boolean

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

schemasGenericConnectMachine

string

oneOf

CONNECT_DEFAULT

No description

CONNECT_64

No description

CONNECT_32

No description

schemasGenericDimensionInfo

object

Properties

qApprMaxGlyphCount
integer<int32>

Length of the longest value in the field.

qCardinal
integer<int32>

Number of distinct field values

qTags
Array<string>

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

qIsSemantic
boolean

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

qAndMode
boolean

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.

schemasGenericDimensionLayout

object

Is the layout for GenericDimensionProperties.

Properties

qInfo

No description

qMeta

Layout for NxMetaDef.

qDim

No description

qDimInfos

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

schemasGenericDimensionProperties

object

Properties

qInfo

No description

qDim

No description

qMetaDef

Used to collect meta data.

Properties

Semantic type with an empty structure.

schemasGenericMeasureLayout

object

Is the layout for GenericMeasureProperties.

Properties

qInfo

No description

qMeasure

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

qMeta

Layout for NxMetaDef.

schemasGenericMeasureProperties

object

Properties

qInfo

No description

qMeasure

No description

qMetaDef

Used to collect meta data.

Properties

Semantic type with an empty structure.

schemasGenericObjectEntry

object

Properties

qProperty

No description

qChildren

Information about the children of the generic object.

qEmbeddedSnapshotRef

No description

schemasGenericObjectLayout

object

Is the layout for GenericObjectProperties.

Properties

qInfo

No description

qMeta

Layout for NxMetaDef.

qExtendsId
string

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.

qHasSoftPatches
boolean

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

qError

No description

qSelectionInfo

No description

qStateName
string

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

schemasGenericObjectProperties

object

Properties

qInfo

No description

qExtendsId
string

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.

qMetaDef

Used to collect meta data.

Properties

Semantic type with an empty structure.

qStateName
string

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

schemasGenericVariableLayout

object

Is the layout for GenericVariableProperties.

Properties

qInfo

No description

qMeta

Layout for NxMetaDef.

qText
string

Some text.

qNum
number<double>

A value.

qIsScriptCreated
boolean

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

schemasGenericVariableProperties

object

Properties

qInfo

No description

qMetaDef

Used to collect meta data.

Properties

Semantic type with an empty structure.

qName
string

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

qComment
string

Comment related to the variable. This parameter is optional.

qNumberPresentation

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qIncludeInBookmark
default=false
boolean

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.

qDefinition
string

Definition of the variable.

schemasGraphMode

string

oneOf

GRAPH_MODE_BAR

No description

GRAPH_MODE_PIE

No description

GRAPH_MODE_PIVOTTABLE

No description

GRAPH_MODE_SCATTER

No description

GRAPH_MODE_LINE

No description

GRAPH_MODE_STRAIGHTTABLE

No description

GRAPH_MODE_COMBO

No description

GRAPH_MODE_RADAR

No description

GRAPH_MODE_GAUGE

No description

GRAPH_MODE_GRID

No description

GRAPH_MODE_BLOCK

No description

GRAPH_MODE_FUNNEL

No description

GRAPH_MODE_MEKKO

No description

GRAPH_MODE_LAST

No description

schemasGroupBookmarkData

object

Properties

qId
string

No description

qCyclePos
integer<int32>

No description

schemasGroupStateInfo

object

Properties

qGroupName
string

No description

qCurrentItemName
string

No description

schemasHyperCube

object

Renders the properties of a hypercube. Is the layout for HyperCubeDef. For more information about the definition of a hypercube, see Generic object.

What is returned in HyperCube depends on the type of the hypercube (straight, pivot or stacked table, or tree) and on the method called (GetLayout, GetHyperCubeData, GetHyperCubePivotData, GetHyperCubeStackData, GetHyperCubeTreeData).

Properties

qStateName
string

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

qSize

No description

qError

No description

qDimensionInfo

Information on the dimension.

qMeasureInfo

Information on the measure.

qEffectiveInterColumnSortOrder
Array<integer<int32>>

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.

qGrandTotalRow

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

qDataPages

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

qPivotDataPages

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

qStackedDataPages

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

qMode

No description

qNoOfLeftDims
integer<int32>

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.
qIndentMode
boolean

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

qLastExpandedPos

No description

qHasOtherValues
boolean

True if other row exists.

qTitle
string

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

qTreeNodesOnDim
Array<integer<int32>>

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

qCalcCondMsg
string

The message displayed if calculation condition is not fulfilled.

qColumnOrder
Array<integer<int32>>

The order of the columns.

schemasHyperCubeDef

object

Defines the properties of a hypercube. For more information about the definition of a hypercube, see Generic object.

Properties

qStateName
string

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

qDimensions

Array of dimensions.

qMeasures

Array of measures.

qInterColumnSortOrder
Array<integer<int32>>

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.

qSuppressZero
default=false
boolean

Removes zero values.

qSuppressMissing
default=false
boolean

Removes missing values.

qInitialDataFetch

Initial data set.

qReductionMode

No description

qMode

No description

qPseudoDimPos
default=-1
integer<int32>

No description

qNoOfLeftDims
default=-1
integer<int32>

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.
qAlwaysFullyExpanded
default=false
boolean

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.

qMaxStackedCells
default=5000
integer<int32>

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

qPopulateMissing
default=false
boolean

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.

qShowTotalsAbove
default=false
boolean

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

qIndentMode
default=false
boolean

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.

qCalcCond

No description

qSortbyYValue
default=0
integer<int8>

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.

qTitle

No description

qCalcCondition

No description

qColumnOrder
Array<integer<int32>>

The order of the columns.

qExpansionState

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

qDynamicScript
Array<string>

Hypercube Modifier Dynamic script string

qContextSetExpression
string

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

schemasInputFieldItem

object

Properties

qFieldName
string

No description

qValues

No description

qPackedHashKeys
Array<integer<byte>>

No description

schemasInterFieldSortData

object

Properties

qName
string

No description

qReversed
boolean

No description

schemasInteractDef

object

Properties

qType

No description

qTitle
string

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

qMsg
string

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

qButtons
integer<int32>

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.
qLine
string

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

qOldLineNr
integer<int32>

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

qNewLineNr
integer<int32>

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

qPath
string

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);

qHidden
boolean

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

qResult
integer<int32>

Not relevant for describing the requested user interaction.

qInput
string

Is not used in Qlik Sense.

schemasInteractType

string

oneOf

IT_MSGBOX

No description

IT_SCRIPTLINE

No description

IT_BREAK

No description

IT_INPUT

No description

IT_END

No description

IT_PASSWD

No description

IT_USERNAME

No description

schemasJsonObject

object

Contains dynamic JSON data specified by the client.

schemasKeyType

string

oneOf

NOT_KEY

No description

ANY_KEY

No description

PRIMARY_KEY

No description

PERFECT_KEY

No description

schemasLayoutBookmarkData

object

Properties

qId
string

No description

qActive
boolean

No description

qShowMode
integer<byte>

No description

qScrollPos

No description

schemasLayoutExclude

object

Contains JSON to be excluded from validation.

schemasLayoutFieldInfo

object

Meta data about the selection in a field.

Properties

qFieldName
string

The name of the field.

qValuesCount
integer<int32>

Number of selected values in the field.

qExcludedValuesCount
integer<int32>

Number of excluded values in the field.

schemasLineageInfo

object

Properties

qDiscriminator
string

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).
qStatement
string

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

schemasListObject

object

Renders the properties of a list object. Is the layout for ListObjectDef. For more information about the definition of a list object, see Generic object.

ListObject is used by the _GetLayout Method_ to display the properties of a list object.

Properties

qStateName
string

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

qSize

No description

qError

No description

qDimensionInfo

No description

qExpressions

Lists the expressions in the list object.

qDataPages

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

schemasListObjectDef

object

Defines the properties of a list object. For more information about the definition of a list object, see Generic object.

Properties

qStateName
string

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

qLibraryId
string

Refers to a dimension stored in the library.

qDef

No description

qAutoSortByState

No description

qFrequencyMode

No description

qShowAlternatives
boolean

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.

qInitialDataFetch

Fetches an initial data set.

qExpressions

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

qDirectQuerySimplifiedView
boolean

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

schemasLocaleInfo

object

Properties

qDecimalSep
string

Decimal separator.

qThousandSep
string

Thousand separator.

qListSep
string

List separator.

qMoneyDecimalSep
string

Money decimal separator.

qMoneyThousandSep
string

Money thousand separator.

qCurrentYear
integer<int32>

Current year.

qMoneyFmt
string

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

qTimeFmt
string

Time format. Example: hh:mm:ss

qDateFmt
string

Date format. Example: YYYY-MM-DD

qTimestampFmt
string

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

qCalendarStrings

No description

qFirstWeekDay
integer<int32>

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.

qBrokenWeeks
boolean

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.

qReferenceDay
integer<int32>

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.

qFirstMonthOfYear
integer<int32>

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.

qCollation
string

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.

qNumericalAbbreviation
string

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

schemasLogOnType

string

oneOf

LOG_ON_SERVICE_USER

No description

LOG_ON_CURRENT_USER

No description

schemasMeasureList

object

Lists the measures. Is the layout for MeasureListDef.

Properties

qItems

Information about the list of measures.

schemasMeasureListDef

object

Defines the list of measures.

Properties

qType
string

Type of the list.

qData

Contains dynamic JSON data specified by the client.

schemasMediaList

object

Lists the media files. Is the layout for MediaListDef.

This struct is deprecated.

Properties

qItems

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 .

schemasMediaListDef

object

Defines the list of media files.

This struct is deprecated.

Properties

"qMediaListDef": {} qMediaListDef has an empty structure. No properties need to be set.

schemasMediaListItem

object
In addition, this structure can return dynamic properties.

Properties

qUrlDef
string

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.
qUrl
string

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.

schemasMetaData

object

Properties

qShared
boolean

No description

qUtcModifyTime
number<double>

No description

qSheetId
string

No description

qTemporary
boolean

No description

qRestrictedAccess
boolean

No description

qAccessList
Array<string>

No description

qPersonalEditionHash_OBSOLETE
string

No description

qHidden
default=false
boolean

No description

qLinkedTo
Array<string>

No description

schemasNxAppLayout

object

Qlik Sense Desktop

In Qlik Sense Desktop, this structure can contain dynamic properties.

Qlik Sense Enterprise

In Qlik Sense Enterprise, only a few dynamic properties at the app level are persisted. The persisted dynamic properties are the following:

  • modifiedDate
  • published
  • publishTime
  • privileges
  • description
  • dynamicColor

Properties

qTitle
string

Title of the app.

qFileName
string

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.

qLastReloadTime
string

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

qModified
boolean

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

qHasScript
boolean

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

qStateNames
Array<string>

Array of alternate states.

qMeta

Layout for NxMetaDef.

qLocaleInfo

No description

qHasData
boolean

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

qReadOnly
boolean

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

qIsOpenedWithoutData
boolean

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

qIsSessionApp
boolean

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

qThumbnail
In addition, this structure can return dynamic properties.
qIsBDILiveMode
boolean

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

qIsDirectQueryMode
boolean

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

qUnsupportedFeatures
Array<NxFeature>

Array of features not supported by the app.

schemasNxAppProperties

object

Qlik Sense Desktop

In Qlik Sense Desktop, this structure can contain dynamic properties.

Qlik Sense Enterprise

In Qlik Sense Enterprise, only a few dynamic properties at the app level are persisted. The persisted dynamic properties are the following:

  • modifiedDate
  • published
  • publishTime
  • privileges
  • description
  • dynamicColor

Properties

qTitle
string

App title.

qLastReloadTime
string

Last reload time of the app.

qMigrationHash
string

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

qSavedInProductVersion
string

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

qThumbnail
In addition, this structure can contain dynamic properties.
qHasSectionAccess
boolean

If true the app has section access configured.

schemasNxAttrDimDef

object

Layout for NxAttrDimDef.

Properties

qDef
string

Expression or field name.

qLibraryId
string

LibraryId for dimension.

qSortBy

No description

qAttribute
boolean

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

schemasNxAttrDimInfo

object

Layout for NxAttrDimDef.

Properties

qCardinal
integer<int32>

Cardinality of the attribute expression.

qSize

No description

qFallbackTitle
string

The title for the attribute dimension.

qLocked
boolean

The Locked value of the dimension.

qError

No description

qIsCalculated
default=false
boolean

True if this is a calculated dimension.

schemasNxAttrExprDef

object

Properties

qExpression
string

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

qLibraryId
string

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

qAttribute
boolean

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

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qLabel
string

Label of the attribute expression.

qLabelExpression
string

Optional expression used for dynamic label.

schemasNxAttrExprInfo

object

Layout for NxAttrExprDef.

Properties

qMin
number<double>

Minimum value.

qMax
number<double>

Maximum value.

qFallbackTitle
string

No description

qMinText
string

String version of the minimum Value.

qMaxText
string

String version of the maximum Value.

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qIsAutoFormat
boolean

This parameter is set to true if qNumFormat is set to U (unknown). The engine guesses the type of the field based on the field's expression.

schemasNxAttributeDimValues

object

Properties

qValues

List of values.

schemasNxAttributeExpressionValues

object

Properties

qValues

List of attribute expressions values.

schemasNxAutoSortByStateDef

object

Properties

qDisplayNumberOfRows
integer<int32>

This parameter applies to list objects. If the number of selected values in the list object is greater than the value set in qDisplayNumberOfRows , the selected lines are promoted at the top of the list object. If qDisplayNumberOfRows is set to a negative value or to 0, the sort by state is disabled.

schemasNxAxisData

object

Properties

qAxis

List of axis data.

schemasNxAxisTicks

object

Properties

qName
string

Name of the derived definition.

qTags
Array<string>

List of tags.

qTicks

List of ticks.

schemasNxBookmark

object

Properties

qStateData

List of selections for each state.

qUtcModifyTime
number<double>

Time when the bookmark was created.

qVariableItems

List of the variables in the app at the time the bookmark was created.

qPatches

Softpatches to be applied with this bookmark.

schemasNxCalcCond

object

Properties

qCond

No description

qMsg

No description

schemasNxCardinalities

object

Properties

qCardinal
integer<int32>

Number of distinct field values.

qHypercubeCardinal
integer<int32>

Number of distinct hypercube values.

qAllValuesCardinal
default=-1
integer<int32>

Number of distinct values when paging for AllValues in a Tree Structure. Default is -1 if not part of a Tree structure.

schemasNxCell

object

Properties

qText
string

Some text. This parameter is optional.

qNum
number<double>

A value. This parameter is optional.

qElemNumber
integer<int32>

Rank number of the value, starting from 0. If the element number is a negative number, it means that the returned value is not an element number. You can get the following negative values:

  • -1: the cell is a Total cell. It shows a total.
  • -2: the cell is a Null cell.
  • -3: the cell belongs to the group Others .
  • -4: the cell is empty. Applies to pivot tables.
qState

No description

qIsEmpty
boolean

Is set to true , if qText and qNum are empty. This parameter is optional. The default value is false .

qIsTotalCell
boolean

Is set to true if a total is displayed in the cell. This parameter is optional. The default value is false . Not applicable to list objects.

qIsOtherCell
boolean

Is set to true if the cell belongs to the group Others . Dimension values can be set as Others depending on what has been defined in OtherTotalSpecProp . This parameter is optional. The default value is false . Not applicable to list objects.

qFrequency
string

Frequency of the value. This parameter is optional.

qHighlightRanges

No description

qAttrExps

No description

qAttrDims

No description

qIsNull
boolean

Is set to true if the value is Null.

qMiniChart

No description

qInExtRow
boolean

No description

schemasNxCellPosition

object

Properties

qx
integer<int32>

Position of the cell on the x-axis.

qy
integer<int32>

Position of the cell on the y-axis.

schemasNxCellRows

Array<NxCell>

schemasNxContainerEntry

object

Properties

qInfo

No description

qMeta

Layout for NxMetaDef.

qData

Contains dynamic JSON data specified by the client.

schemasNxContinuousDataOptions

object

Properties

qStart
number<double>

Start value.

qEnd
number<double>

End value.

qNbrPoints
integer<int32>

Number of bins for binning.

qMaxNbrTicks
integer<int32>

Maximum number of ticks.

qMaxNumberLines
default=-1
integer<int32>

Maximum number of lines.

schemasNxContinuousMode

string

oneOf

Never

CONTINUOUS_NEVER

Possible

CONTINUOUS_IF_POSSIBLE

Time

CONTINUOUS_IF_TIME

schemasNxContinuousRangeSelectInfo

object

Properties

qRange

No description

qDimIx
integer<int32>

Dimension index.

schemasNxCurrentSelectionItem

object

Properties

qTotal
integer<int32>

Number of values in the field.

qIsNum
boolean

This parameter is displayed if its value is true. Is set to true if the field is a numeric. This parameter is optional.

qField
string

Name of the field that is selected.

qLocked
boolean

This parameter is displayed if its value is true. Is set to true if the field is locked. This parameter is optional.

qOneAndOnlyOne
boolean

This parameter is displayed if its value is true. Property that is set to a field. Is set to true if the field cannot be unselected. This parameter is optional.

qTextSearch
string

Text that was used for the search. This parameter is filled when searching for a value and selecting it. This parameter is optional.

qSelectedCount
integer<int32>

Number of values that are selected.

qSelected
string

Values that are selected.

qRangeInfo

Information about the range of selected values. Is empty if there is no range of selected values.

qSortIndex
integer<int32>

Sort index of the field. Indexing starts from 0.

qStateCounts

No description

qSelectedFieldSelectionInfo

Information about the fields that are selected.

qNotSelectedFieldSelectionInfo

Information about the fields that are not selected.

qSelectionThreshold
integer<int32>

Maximum values to show in the current selections. The default value is 6.

qReadableName
string

Label that, if defined, is displayed in current selections instead of the actual expression.

qIsHidden
boolean

Optional parameter. Indicates if the selection is to be hidden in the Selections bar. Is set to true if the current selection is hidden.

schemasNxDataAreaPage

object

Properties

qLeft
number<double>

Position from the left. Corresponds to the lowest possible value of the first measure (the measure on the x-axis).

qTop
number<double>

Position from the top. Corresponds to the highest possible value of the second measure (the measure on the y-axis).

qWidth
number<double>

Width of the page. Corresponds to the highest possible value of the first measure (the measure on the x-axis).

qHeight
number<double>

Height of the page. The difference between qTop and qHeight gives the lowest possible value of the second measure (the measure on the y-axis).

schemasNxDataPage

object

Properties

qMatrix
Array<Array<NxCell>>

Array of data.

qTails

Array of tails. Is used for hypercube objects with multiple dimensions. It might happen that due to the window size some elements in a group cannot be displayed in the same page as the other elements of the group. Elements of a group of dimensions can be part of the previous or the next tail. If there is no tail, the array is empty [ ] .

qArea

No description

qIsReduced
default=false
boolean

Is set to true, if the data have been reduced. The default value is false.

schemasNxDataReductionMode

string

oneOf

N

DATA_REDUCTION_NONE

D1

DATA_REDUCTION_ONEDIM

S

DATA_REDUCTION_SCATTERED

C

DATA_REDUCTION_CLUSTERED

ST

DATA_REDUCTION_STACKED

schemasNxDerivedField

object

Properties

qId
string

Identifier of the derived field. The identifier is unique.

qName
string

Combination of field name, definition and method. Example: OrderDate.MyDefinition.Year

qMethod
string

Method name associated to the derived field.

qExpr
string

Expression of the derived field. Example: If qName is OrderDate.MyDefinition.Year , the expression is as follows: =${Mydefinition(OrderDate).Year}

qTags
Array<string>

List of tags.

schemasNxDerivedFieldDescriptionList

object

Properties

qDerivedFieldLists

Information about the derived fields.

schemasNxDerivedFieldsData

object

Properties

qDerivedDefinitionName
string

Name of the derived definition.

qFieldDefs

List of the derived fields.

qGroupDefs

List of the derived groups.

qTags
Array<string>

List of tags on the derived fields.

schemasNxDerivedGroup

object

Properties

qId
string

Identifier of the group.

qName
string

Name of the derived group.

qGrouping

No description

qFieldDefs
Array<string>

List of the derived fields in the group.

schemasNxDimCellType

string

oneOf

V

NX_DIM_CELL_VALUE

E

NX_DIM_CELL_EMPTY

N

NX_DIM_CELL_NORMAL

T

NX_DIM_CELL_TOTAL

O

NX_DIM_CELL_OTHER

A

NX_DIM_CELL_AGGR

P

NX_DIM_CELL_PSEUDO

R

NX_DIM_CELL_ROOT

U

NX_DIM_CELL_NULL

G

NX_DIM_CELL_GENERATED

schemasNxDimension

object
Either **qDef** or **qLibraryId** must be set, but not both.
If the dimension is set in the hypercube and not in the library, this dimension cannot be shared with other objects.
A dimension that is set in the library can be used by many objects.

Properties

qLibraryId
string

Refers to a dimension stored in the library.

qDef

No description

qNullSuppression
boolean

If set to true, no null values are returned.

qIncludeElemValue
boolean

No description

qOtherTotalSpec

No description

qShowTotal
boolean

No description

qShowAll
boolean

If set to true, all dimension values are shown.

qOtherLabel

No description

qTotalLabel

No description

qCalcCond

No description

qAttributeExpressions

List of attribute expressions.

qAttributeDimensions

List of attribute dimensions.

qCalcCondition

No description

schemasNxDimensionInfo

object

Properties

qFallbackTitle
string

Corresponds to the label of the dimension that is selected. If the label is not defined then the field name is used.

qApprMaxGlyphCount
integer<int32>

Length of the longest value in the field.

qCardinal
deprecated
integer<int32>

Number of distinct field values.

qLocked
boolean

Is set to true if the field is locked.

qSortIndicator

No description

qGroupFallbackTitles
Array<string>

Array of dimension labels. Contains the labels of all dimensions in a hierarchy group (for example the labels of all dimensions in a drill down group).

qGroupPos
integer<int32>

Index of the dimension that is currently in use. qGroupPos is set to 0 if there are no hierarchical groups (drill-down groups) or cycle groups.

qStateCounts

No description

qTags
Array<string>

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

qError

No description

qDimensionType

No description

qReverseSort
boolean

If set to true, it inverts the sort criteria in the field.

qGrouping

No description

qIsSemantic
boolean

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

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qIsAutoFormat
boolean

This parameter is set to true if qNumFormat is set to U (unknown). The engine guesses the type of the field based on the field's definition.

qGroupFieldDefs
Array<string>

Array of field names.

qMin
number<double>

Minimum value.

qMax
number<double>

Maximum value.

qContinuousAxes
boolean

Is continuous axis used.

qIsCyclic
boolean

Is a cyclic dimension used.

qDerivedField
boolean

Is derived field is used as a dimension.

qAttrExprInfo

Array of attribute expressions.

qAttrDimInfo

Array of attribute dimensions.

qCalcCondMsg
string

The message displayed if calculation condition is not fulfilled.

qIsCalculated
default=false
boolean

True if this is a calculated dimension.

qIsOneAndOnlyOne
boolean

If set to true, it means that the field always has one and only one selected value.

qCardinalities

No description

qLibraryId
string

Refers to a dimension stored in the library.

schemasNxDimensionType

string

oneOf

D

NX_DIMENSION_TYPE_DISCRETE

N

NX_DIMENSION_TYPE_NUMERIC

T

NX_DIMENSION_TYPE_TIME

schemasNxDownloadInfo

object

Properties

qUrl
string

URL to download the reduced app on.

qFileSize
default=-1
integer<int32>

The filesize of the reduced app.

schemasNxDownloadOptions

object

Properties

qBookmarkId
string

Bookmark Id to apply before reducing the application.

qExpires
default=3600
integer<int32>

Time in seconds for how long the download link is valid.

qServeOnce
default=false
boolean

No description

schemasNxEngineVersion

object

Properties

qComponentVersion
string

Version number of the Qlik engine component.

schemasNxExportFileType

string

oneOf

CSV_C

EXPORT_CSV_C

CSV_T

EXPORT_CSV_T

OOXML

EXPORT_OOXML

schemasNxExportState

string

oneOf

P

EXPORT_POSSIBLE

A

EXPORT_ALL

schemasNxFeature

string

oneOf

binningData

FEATURE_BINNING_DATA

bookmarks

FEATURE_BOOKMARKS

calculatedFields

FEATURE_CALCULATED_FIELDS

continuousData

FEATURE_CONTINUOUS_DATA

invertedSelections

FEATURE_INVERTED_SELECTIONS

rangeSelections

FEATURE_RANGE_SELECTIONS

reducingData

FEATURE_REDUCING_DATA

search

FEATURE_SEARCH

selectionCount

FEATURE_SELECTION_COUNT

selectionInsights

FEATURE_SELECTION_INSIGHTS

tableMiniChart

FEATURE_TABLE_MINI_CHART

trendlines

FEATURE_TRENDLINES

calculatedDimensions

FEATURE_CALCULATED_DIMENSIONS

includeZeroValues

FEATURE_INCLUDE_ZERO_VALUES

includeNullValues

FEATURE_INCLUDE_NULL_VALUES

filterPanePaging

FEATURE_FILTER_PANE_PAGING

filterPaneCustomSorting

FEATURE_FILTER_PANE_CUSTOM_SORTING

showFrequency

FEATURE_SHOW_FREQUENCY

limitation

FEATURE_LIMITATION

totals

FEATURE_TOTALS

schemasNxFieldDescription

object

NxDerivedFieldsdata

NameDescriptionType
qDerivedDefinitionNameName of the derived definition.String
qFieldDefsList of the derived fields.Array of NxDerivedField
qGroupDefsList of the derived groups.Array of NxDerivedGroup
qTagsList of tags on the derived fields.Array of String

Properties

qIsSemantic
boolean

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

qIsHidden
boolean

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

qIsSystem
boolean

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

qAndMode
boolean

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.

qName
string

Name of the field

qCardinal
integer<int32>

Number of distinct field values

qTags
Array<string>

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

qIsDefinitionOnly
boolean

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

qDerivedFieldData

No description

qIsDetail
boolean

Is used for Direct Discovery. If set to true, it means that the type of the field is detail.

qIsImplicit
boolean

Is used for Direct Discovery. If set to true, it means that the type of the field is measure.

qReadableName
string

No description

schemasNxFieldProperties

object

Properties

qOneAndOnlyOne
boolean

This parameter is set to true, if 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 property _OneAndOnlyOne_ can be set to true if one and only value has been selected in the field prior to setting the property.

schemasNxFieldResourceId

object

Properties

qName
string

Name of the field to get the resource id for.

qResourceIds

Field level resource Id per table that the field is part of

schemasNxFieldSelectionInfo

object

Properties

qName
string

Name of the field.

qFieldSelectionMode

No description

schemasNxFieldSelectionMode

string

oneOf

NORMAL

SELECTION_MODE_NORMAL

AND

SELECTION_MODE_AND

NOT

SELECTION_MODE_NOT

schemasNxFieldTableResourceId

object

Properties

qTable
string

Name of the table that the field belongs to get the resource id for

qResourceId
string

Resource identifier for the field

schemasNxFrequencyMode

string

oneOf

N

NX_FREQUENCY_NONE

V

NX_FREQUENCY_VALUE

P

NX_FREQUENCY_PERCENT

R

NX_FREQUENCY_RELATIVE

schemasNxGetBookmarkOptions

object

Properties

qTypes
Array<string>

List of object types.

qData

Contains dynamic JSON data specified by the client.

qIncludePatches
boolean

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

schemasNxGetObjectOptions

object

Properties

qTypes
Array<string>

List of object types.

qIncludeSessionObjects
default=false
boolean

Set to true to include session objects. The default value is false.

qData

Contains dynamic JSON data specified by the client.

schemasNxGroupTail

object

Properties

qUp
integer<int32>

Number of elements that are part of the previous tail. This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight . Is not shown if the value is 0. This parameter is optional.

qDown
integer<int32>

Number of elements that are part of the next tail. This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight Is not shown if the value is 0. This parameter is optional.

schemasNxGrpType

string

oneOf

N

GRP_NX_NONE

H

GRP_NX_HIEARCHY

C

GRP_NX_COLLECTION

schemasNxHighlightRanges

object

Properties

qRanges

Ranges of highlighted values.

schemasNxHypercubeMode

string

oneOf

S

DATA_MODE_STRAIGHT

P

DATA_MODE_PIVOT

K

DATA_MODE_PIVOT_STACK

T

DATA_MODE_TREE

D

DATA_MODE_DYNAMIC

schemasNxInfo

object

Properties

qId
string

Identifier of the object. If the chosen identifier is already in use, the engine automatically sets another one. If an identifier is not set, the engine automatically sets one. This parameter is optional.

qType
string

Type of the object. This parameter is mandatory.

schemasNxInlineDimensionDef

object

Properties

qGrouping

No description

qFieldDefs
Array<string>

Array of field names. When creating a grouped dimension, more than one field name is defined. This parameter is optional.

qFieldLabels
Array<string>

Array of field labels. This parameter is optional.

qSortCriterias

Defines the sorting criteria in the field. Default is to sort by alphabetical order, ascending. This parameter is optional.

qNumberPresentations

Defines the format of the value. This parameter is optional.

qReverseSort
boolean

If set to true, it inverts the sort criteria in the field.

qActiveField
integer<int32>

Index of the active field in a cyclic dimension. This parameter is optional. The default value is 0. This parameter is used in case of cyclic dimensions ( qGrouping is C).

qLabelExpression
string

Label expression. This parameter is optional.

schemasNxInlineMeasureDef

object

Properties

qLabel
string

Name of the measure. An empty string is returned as a default value. This parameter is optional.

qDescription
string

Description of the measure. An empty string is returned as a default value. This parameter is optional.

qTags
Array<string>

Name connected to the measure that is used for search purposes. A measure can have several tags. This parameter is optional.

qGrouping

No description

qDef
string

Definition of the expression in the measure. Example: Sum (OrderTotal) This parameter is mandatory.

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qRelative
boolean

If set to true, percentage values are returned instead of absolute numbers. Default value is false. This parameter is optional.

qBrutalSum
boolean

If set to true, the sum of rows total should be used rather than real expression total. This parameter is optional and applies to straight tables. Default value is false. If using the Qlik Sense interface, it means that the total mode is set to Expression Total .

qAggrFunc
string

Aggregate function. For more information on the aggregate function syntax, see the section Working with Qlik Sense on the online help portal. The default value is 0 (Sum of rows) This parameter is optional.

qAccumulate
integer<int32>
  • 0 means no accumulation * 1 means full accumulation (each y-value accumulates all previous y-values of the expression) * ≥ 2 means accumulate as many steps as the qAccumulate value Default value is 0. This parameter is optional.
qReverseSort
boolean

If set to true, it inverts the sort criteria in the field.

qActiveExpression
integer<int32>

Index of the active expression in a cyclic measure. The indexing starts from 0. The default value is 0. This parameter is optional.

qExpressions
Array<string>

Array of expressions. This parameter is used in case of cyclic measures ( qGrouping is C). List of the expressions in the cyclic group.

qLabelExpression
string

Label expression. This parameter is optional.

schemasNxLTrendlineType

string

oneOf

AVERAGE

Average

LINEAR

Linear

POLYNOMIAL2

Polynomial2

POLYNOMIAL3

Polynomial3

POLYNOMIAL4

Polynomial4

EXPONENTIAL

Exponential

POWER

Power

LOG

Logarithmic

schemasNxLayoutErrors

object

Properties

qErrorCode
integer<int32>

Error code.

schemasNxLibraryDimension

object

Properties

qGrouping

No description

qFieldDefs
Array<string>

Array of dimension names.

qFieldLabels
Array<string>

Array of dimension labels.

qLabelExpression
string

No description

schemasNxLibraryDimensionDef

object

Properties

qGrouping

No description

qFieldDefs
Array<string>

Array of dimension names.

qFieldLabels
Array<string>

Array of dimension labels.

qLabelExpression
string

No description

schemasNxLibraryMeasure

object

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

Properties

qLabel
string

No description

qDef
string

No description

qGrouping

No description

qExpressions
Array<string>

No description

qActiveExpression
integer<int32>

No description

qLabelExpression
string

No description

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

schemasNxLibraryMeasureDef

object

Properties

qLabel
string

Label of the measure.

qDef
string

Definition of the measure.

qGrouping

No description

qExpressions
Array<string>

Array of expressions.

qActiveExpression
integer<int32>

Index to the active expression in a measure.

qLabelExpression
string

Optional expression used for dynamic label.

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

schemasNxLinkedObjectInfo

object

Properties

qRootId
string

Identifier of the root object. If the linked object is a child, the root identifier is the identifier of the parent. If the linked object is an app object, the root identifier is the same than the identifier of the linked object since the linked object is a root object.

qInfo

No description

schemasNxListObjectExpression

object

Properties

qExpr
string

Value of the expression.

qError

No description

schemasNxListObjectExpressionDef

object

Properties

qExpr
string

Value of the expression.

qLibraryId
string

Refers to an expression stored in the library.

schemasNxLocalizedErrorCode

string

oneOf

LOCERR_INTERNAL_ERROR

No description

LOCERR_GENERIC_UNKNOWN

No description

LOCERR_GENERIC_OK

No description

LOCERR_GENERIC_NOT_SET

No description

LOCERR_GENERIC_NOT_FOUND

No description

LOCERR_GENERIC_ALREADY_EXISTS

No description

LOCERR_GENERIC_INVALID_PATH

No description

LOCERR_GENERIC_ACCESS_DENIED

No description

LOCERR_GENERIC_OUT_OF_MEMORY

No description

LOCERR_GENERIC_NOT_INITIALIZED

No description

LOCERR_GENERIC_INVALID_PARAMETERS

No description

LOCERR_GENERIC_EMPTY_PARAMETERS

No description

LOCERR_GENERIC_INTERNAL_ERROR

No description

LOCERR_GENERIC_CORRUPT_DATA

No description

LOCERR_GENERIC_MEMORY_INCONSISTENCY

No description

LOCERR_GENERIC_INVISIBLE_OWNER_ABORT

No description

LOCERR_GENERIC_PROHIBIT_VALIDATE

No description

LOCERR_GENERIC_ABORTED

No description

LOCERR_GENERIC_CONNECTION_LOST

No description

LOCERR_GENERIC_UNSUPPORTED_IN_PRODUCT_VERSION

No description

LOCERR_GENERIC_REST_CONNECTION_FAILURE

No description

LOCERR_GENERIC_MEMORY_LIMIT_REACHED

No description

LOCERR_GENERIC_NOT_IMPLEMENTED

No description

LOCERR_HTTP_400

No description

LOCERR_HTTP_401

No description

LOCERR_HTTP_402

No description

LOCERR_HTTP_403

No description

LOCERR_HTTP_404

No description

LOCERR_HTTP_405

No description

LOCERR_HTTP_406

No description

LOCERR_HTTP_407

No description

LOCERR_HTTP_408

No description

LOCERR_HTTP_409

No description

LOCERR_HTTP_410

No description

LOCERR_HTTP_411

No description

LOCERR_HTTP_412

No description

LOCERR_HTTP_413

No description

LOCERR_HTTP_414

No description

LOCERR_HTTP_415

No description

LOCERR_HTTP_416

No description

LOCERR_HTTP_417

No description

LOCERR_HTTP_422

No description

LOCERR_HTTP_429

No description

LOCERR_HTTP_500

No description

LOCERR_HTTP_501

No description

LOCERR_HTTP_502

No description

LOCERR_HTTP_503

No description

LOCERR_HTTP_504

No description

LOCERR_HTTP_505

No description

LOCERR_HTTP_509

No description

LOCERR_HTTP_COULD_NOT_RESOLVE_HOST

No description

LOCERR_APP_ALREADY_EXISTS

No description

LOCERR_APP_INVALID_NAME

No description

LOCERR_APP_ALREADY_OPEN

No description

LOCERR_APP_NOT_FOUND

No description

LOCERR_APP_IMPORT_FAILED

No description

LOCERR_APP_SAVE_FAILED

No description

LOCERR_APP_CREATE_FAILED

No description

LOCERR_APP_INVALID

No description

LOCERR_APP_CONNECT_FAILED

No description

LOCERR_APP_ALREADY_OPEN_IN_DIFFERENT_MODE

No description

LOCERR_APP_MIGRATION_COULD_NOT_CONTACT_MIGRATION_SERVICE

No description

LOCERR_APP_MIGRATION_COULD_NOT_START_MIGRATION

No description

LOCERR_APP_MIGRATION_FAILURE

No description

LOCERR_APP_SCRIPT_MISSING

No description

LOCERR_APP_EXPORT_FAILED

No description

LOCERR_APP_SIZE_EXCEEDED

No description

LOCERR_APP_DIRECT_QUERY_WORKLOAD_NOT_SUPPORTED

No description

LOCERR_CONNECTION_ALREADY_EXISTS

No description

LOCERR_CONNECTION_NOT_FOUND

No description

LOCERR_CONNECTION_FAILED_TO_LOAD

No description

LOCERR_CONNECTION_FAILED_TO_IMPORT

No description

LOCERR_CONNECTION_NAME_IS_INVALID

No description

LOCERR_CONNECTION_MISSING_CREDENTIALS

No description

LOCERR_CONNECTOR_NO_FILE_STREAMING_SUPPORT

No description

LOCERR_CONNECTOR_FILESIZE_EXCEEDED_BUFFER_SIZE

No description

LOCERR_FILE_ACCESS_DENIED

No description

LOCERR_FILE_NAME_INVALID

No description

LOCERR_FILE_CORRUPT

No description

LOCERR_FILE_NOT_FOUND

No description

LOCERR_FILE_FORMAT_UNSUPPORTED

No description

LOCERR_FILE_OPENED_IN_UNSUPPORTED_MODE

No description

LOCERR_FILE_TABLE_NOT_FOUND

No description

LOCERR_USER_ACCESS_DENIED

No description

LOCERR_USER_IMPERSONATION_FAILED

No description

LOCERR_SERVER_OUT_OF_SESSION_AND_USER_CALS

No description

LOCERR_SERVER_OUT_OF_SESSION_CALS

No description

LOCERR_SERVER_OUT_OF_USAGE_CALS

No description

LOCERR_SERVER_OUT_OF_CALS

No description

LOCERR_SERVER_OUT_OF_NAMED_CALS

No description

LOCERR_SERVER_OFF_DUTY

No description

LOCERR_SERVER_BUSY

No description

LOCERR_SERVER_LICENSE_EXPIRED

No description

LOCERR_SERVER_AJAX_DISABLED

No description

LOCERR_SERVER_NO_TOKEN

No description

LOCERR_HC_INVALID_OBJECT

No description

LOCERR_HC_RESULT_TOO_LARGE

No description

LOCERR_HC_INVALID_OBJECT_STATE

No description

LOCERR_HC_MODAL_OBJECT_ERROR

No description

LOCERR_CALC_INVALID_DEF

No description

LOCERR_CALC_NOT_IN_LIB

No description

LOCERR_CALC_HEAP_ERROR

No description

LOCERR_CALC_TOO_LARGE

No description

LOCERR_CALC_TIMEOUT

No description

LOCERR_CALC_EVAL_CONDITION_FAILED

No description

LOCERR_CALC_MIXED_LINKED_AGGREGATION

No description

LOCERR_CALC_MISSING_LINKED

No description

LOCERR_CALC_INVALID_COL_SORT

No description

LOCERR_CALC_PAGES_TOO_LARGE

No description

LOCERR_CALC_SEMANTIC_FIELD_NOT_ALLOWED

No description

LOCERR_CALC_VALIDATION_STATE_INVALID

No description

LOCERR_CALC_PIVOT_DIMENSIONS_ALREADY_EXISTS

No description

LOCERR_CALC_MISSING_LINKED_FIELD

No description

LOCERR_CALC_NOT_CALCULATED

No description

LOCERR_LAYOUT_EXTENDS_INVALID_ID

No description

LOCERR_LAYOUT_LINKED_OBJECT_NOT_FOUND

No description

LOCERR_LAYOUT_LINKED_OBJECT_INVALID

No description

LOCERR_PERSISTENCE_WRITE_FAILED

No description

LOCERR_PERSISTENCE_READ_FAILED

No description

LOCERR_PERSISTENCE_DELETE_FAILED

No description

LOCERR_PERSISTENCE_NOT_FOUND

No description

LOCERR_PERSISTENCE_UNSUPPORTED_VERSION

No description

LOCERR_PERSISTENCE_MIGRATION_FAILED_READ_ONLY

No description

LOCERR_PERSISTENCE_MIGRATION_CANCELLED

No description

LOCERR_PERSISTENCE_MIGRATION_BACKUP_FAILED

No description

LOCERR_PERSISTENCE_DISK_FULL

No description

LOCERR_PERSISTENCE_NOT_SUPPORTED_FOR_SESSION_APP

No description

LOCERR_PERSISTENCE_MOVE_FAILED

No description

LOCERR_PERSISTENCE_SYNC_SET_CHUNK_INVALID_PARAMETERS

No description

LOCERR_PERSISTENCE_SYNC_GET_CHUNK_INVALID_PARAMETERS

No description

LOCERR_SCRIPT_DATASOURCE_ACCESS_DENIED

No description

LOCERR_RELOAD_IN_PROGRESS

No description

LOCERR_RELOAD_TABLE_X_NOT_FOUND

No description

LOCERR_RELOAD_UNKNOWN_STATEMENT

No description

LOCERR_RELOAD_EXPECTED_SOMETHING_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_NOTHING_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_1_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_2_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_3_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_4_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_5_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_6_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_7_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_EXPECTED_ONE_OF_8_OR_MORE_TOKENS_FOUND_UNKNOWN

No description

LOCERR_RELOAD_FIELD_X_NOT_FOUND

No description

LOCERR_RELOAD_MAPPING_TABLE_X_NOT_FOUND

No description

LOCERR_RELOAD_LIB_CONNECTION_X_NOT_FOUND

No description

LOCERR_RELOAD_NAME_ALREADY_TAKEN

No description

LOCERR_RELOAD_WRONG_FILE_FORMAT_DIF

No description

LOCERR_RELOAD_WRONG_FILE_FORMAT_BIFF

No description

LOCERR_RELOAD_WRONG_FILE_FORMAT_ENCRYPTED

No description

LOCERR_RELOAD_OPEN_FILE_ERROR

No description

LOCERR_RELOAD_AUTO_GENERATE_COUNT

No description

LOCERR_RELOAD_PE_ILLEGAL_PREFIX_COMB

No description

LOCERR_RELOAD_MATCHING_CONTROL_STATEMENT_ERROR

No description

LOCERR_RELOAD_MATCHING_LIBPATH_X_NOT_FOUND

No description

LOCERR_RELOAD_MATCHING_LIBPATH_X_INVALID

No description

LOCERR_RELOAD_MATCHING_LIBPATH_X_OUTSIDE

No description

LOCERR_RELOAD_NO_QUALIFIED_PATH_FOR_FILE

No description

LOCERR_RELOAD_MODE_STATEMENT_ONLY_FOR_LIB_PATHS

No description

LOCERR_RELOAD_INCONSISTENT_USE_OF_SEMANTIC_FIELDS

No description

LOCERR_RELOAD_NO_OPEN_DATABASE

No description

LOCERR_RELOAD_AGGREGATION_REQUIRED_BY_GROUP_BY

No description

LOCERR_RELOAD_CONNECT_MUST_USE_LIB_PREFIX_IN_THIS_MODE

No description

LOCERR_RELOAD_ODBC_CONNECT_FAILED

No description

LOCERR_RELOAD_OLEDB_CONNECT_FAILED

No description

LOCERR_RELOAD_CUSTOM_CONNECT_FAILED

No description

LOCERR_RELOAD_ODBC_READ_FAILED

No description

LOCERR_RELOAD_OLEDB_READ_FAILED

No description

LOCERR_RELOAD_CUSTOM_READ_FAILED

No description

LOCERR_RELOAD_BINARY_LOAD_PROHIBITED

No description

LOCERR_RELOAD_CONNECTOR_START_FAILED

No description

LOCERR_RELOAD_CONNECTOR_NOT_RESPONDING

No description

LOCERR_RELOAD_CONNECTOR_REPLY_ERROR

No description

LOCERR_RELOAD_CONNECTOR_CONNECT_ERROR

No description

LOCERR_RELOAD_CONNECTOR_NOT_FOUND_ERROR

No description

LOCERR_RELOAD_INPUT_FIELD_WITH_DUPLICATE_KEYS

No description

LOCERR_RELOAD_CONCATENATE_LOAD_NO_PREVIOUS_TABLE

No description

LOCERR_RELOAD_WRONG_FILE_FORMAT_QVD

No description

LOCERR_PERSONAL_NEW_VERSION_AVAILABLE

No description

LOCERR_PERSONAL_VERSION_EXPIRED

No description

LOCERR_PERSONAL_SECTION_ACCESS_DETECTED

No description

LOCERR_PERSONAL_APP_DELETION_FAILED

No description

LOCERR_USER_AUTHENTICATION_FAILURE

No description

LOCERR_EXPORT_OUT_OF_MEMORY

No description

LOCERR_EXPORT_NO_DATA

No description

LOCERR_SYNC_INVALID_OFFSET

No description

LOCERR_SEARCH_TIMEOUT

No description

LOCERR_DIRECT_DISCOVERY_LINKED_EXPRESSION_FAIL

No description

LOCERR_DIRECT_DISCOVERY_ROWCOUNT_OVERFLOW

No description

LOCERR_DIRECT_DISCOVERY_EMPTY_RESULT

No description

LOCERR_DIRECT_DISCOVERY_DB_CONNECTION_FAILED

No description

LOCERR_DIRECT_DISCOVERY_MEASURE_NOT_ALLOWED

No description

LOCERR_DIRECT_DISCOVERY_DETAIL_NOT_ALLOWED

No description

LOCERR_DIRECT_DISCOVERY_NOT_SYNTH_CIRCULAR_ALLOWED

No description

LOCERR_DIRECT_DISCOVERY_ONLY_ONE_DD_TABLE_ALLOWED

No description

LOCERR_DIRECT_DISCOVERY_DB_AUTHORIZATION_FAILED

No description

LOCERR_SMART_LOAD_TABLE_NOT_FOUND

No description

LOCERR_SMART_LOAD_TABLE_DUPLICATED

No description

LOCERR_VARIABLE_NO_NAME

No description

LOCERR_VARIABLE_DUPLICATE_NAME

No description

LOCERR_VARIABLE_INCONSISTENCY

No description

LOCERR_MEDIA_LIBRARY_LIST_FAILED

No description

LOCERR_MEDIA_LIBRARY_CONTENT_FAILED

No description

LOCERR_MEDIA_BUNDLING_FAILED

No description

LOCERR_MEDIA_UNBUNDLING_FAILED

No description

LOCERR_MEDIA_LIBRARY_NOT_FOUND

No description

LOCERR_FEATURE_DISABLED

No description

LOCERR_JSON_RPC_INVALID_REQUEST

No description

LOCERR_JSON_RPC_METHOD_NOT_FOUND

No description

LOCERR_JSON_RPC_INVALID_PARAMETERS

No description

LOCERR_JSON_RPC_INTERNAL_ERROR

No description

LOCERR_JSON_RPC_PARSE_ERROR

No description

LOCERR_MQ_SOCKET_CONNECT_FAILURE

No description

LOCERR_MQ_SOCKET_OPEN_FAILURE

No description

LOCERR_MQ_PROTOCOL_NO_RESPONE

No description

LOCERR_MQ_PROTOCOL_LIBRARY_EXCEPTION

No description

LOCERR_MQ_PROTOCOL_CONNECTION_CLOSED

No description

LOCERR_MQ_PROTOCOL_CHANNEL_CLOSED

No description

LOCERR_MQ_PROTOCOL_UNKNOWN_ERROR

No description

LOCERR_MQ_PROTOCOL_INVALID_STATUS

No description

LOCERR_EXTENGINE_GRPC_STATUS_OK

No description

LOCERR_EXTENGINE_GRPC_STATUS_CANCELLED

No description

LOCERR_EXTENGINE_GRPC_STATUS_UNKNOWN

No description

LOCERR_EXTENGINE_GRPC_STATUS_INVALID_ARGUMENT

No description

LOCERR_EXTENGINE_GRPC_STATUS_DEADLINE_EXCEEDED

No description

LOCERR_EXTENGINE_GRPC_STATUS_NOT_FOUND

No description

LOCERR_EXTENGINE_GRPC_STATUS_ALREADY_EXISTS

No description

LOCERR_EXTENGINE_GRPC_STATUS_PERMISSION_DENIED

No description

LOCERR_EXTENGINE_GRPC_STATUS_RESOURCE_EXHAUSTED

No description

LOCERR_EXTENGINE_GRPC_STATUS_FAILED_PRECONDITION

No description

LOCERR_EXTENGINE_GRPC_STATUS_ABORTED

No description

LOCERR_EXTENGINE_GRPC_STATUS_OUT_OF_RANGE

No description

LOCERR_EXTENGINE_GRPC_STATUS_UNIMPLEMENTED

No description

LOCERR_EXTENGINE_GRPC_STATUS_INTERNAL

No description

LOCERR_EXTENGINE_GRPC_STATUS_UNAVAILABLE

No description

LOCERR_EXTENGINE_GRPC_STATUS_DATA_LOSS

No description

LOCERR_EXTENGINE_GRPC_STATUS_UNAUTHENTICATED

No description

LOCERR_LXW_INVALID_OBJ

No description

LOCERR_LXW_INVALID_FILE

No description

LOCERR_LXW_INVALID_SHEET

No description

LOCERR_LXW_INVALID_EXPORT_RANGE

No description

LOCERR_LXW_ERROR

No description

LOCERR_LXW_ERROR_MEMORY_MALLOC_FAILED

No description

LOCERR_LXW_ERROR_CREATING_XLSX_FILE

No description

LOCERR_LXW_ERROR_CREATING_TMPFILE

No description

LOCERR_LXW_ERROR_ZIP_FILE_OPERATION

No description

LOCERR_LXW_ERROR_ZIP_FILE_ADD

No description

LOCERR_LXW_ERROR_ZIP_CLOSE

No description

LOCERR_LXW_ERROR_NULL_PARAMETER_IGNORED

No description

LOCERR_LXW_ERROR_MAX_STRING_LENGTH_EXCEEDED

No description

LOCERR_LXW_ERROR_255_STRING_LENGTH_EXCEEDED

No description

LOCERR_LXW_ERROR_SHARED_STRING_INDEX_NOT_FOUND

No description

LOCERR_LXW_ERROR_WORKSHEET_INDEX_OUT_OF_RANGE

No description

LOCERR_LXW_ERROR_WORKSHEET_MAX_NUMBER_URLS_EXCEEDED

No description

LOCERR_BDI_STATUS_OK

No description

LOCERR_BDI_GENERIC_ERROR_NOT_TRANSLATED

No description

LOCERR_TRENDLINE_INVALID_DEF

No description

LOCERR_TRENDLINE_INVALID_MATH_ERROR

No description

LOCERR_CURL_UNSUPPORTED_PROTOCOL

No description

LOCERR_CURL_COULDNT_RESOLVE_PROXY

No description

LOCERR_CURL_COULDNT_CONNECT

No description

LOCERR_CURL_REMOTE_ACCESS_DENIED

No description

LOCERR_CURL_FTP_ACCEPT_FAILED

No description

LOCERR_CURL_FTP_ACCEPT_TIMEOUT

No description

LOCERR_CURL_FTP_CANT_GET_HOST

No description

LOCERR_CURL_PARTIAL_FILE

No description

LOCERR_CURL_QUOTE_ERROR

No description

LOCERR_CURL_WRITE_ERROR

No description

LOCERR_CURL_UPLOAD_FAILED

No description

LOCERR_CURL_OUT_OF_MEMORY

No description

LOCERR_CURL_OPERATION_TIMEDOUT

No description

LOCERR_CURL_FTP_COULDNT_USE_REST

No description

LOCERR_CURL_HTTP_POST_ERROR

No description

LOCERR_CURL_SSL_CONNECT_ERROR

No description

LOCERR_CURL_FILE_COULDNT_READ_FILE

No description

LOCERR_CURL_LDAP_CANNOT_BIND

No description

LOCERR_CURL_LDAP_SEARCH_FAILED

No description

LOCERR_CURL_TOO_MANY_REDIRECTS

No description

LOCERR_CURL_PEER_FAILED_VERIFICATION

No description

LOCERR_CURL_GOT_NOTHING

No description

LOCERR_CURL_SSL_ENGINE_NOTFOUND

No description

LOCERR_CURL_SSL_ENGINE_SETFAILED

No description

LOCERR_CURL_SSL_CERTPROBLEM

No description

LOCERR_CURL_SSL_CIPHER

No description

LOCERR_CURL_SSL_CACERT

No description

LOCERR_CURL_BAD_CONTENT_ENCODING

No description

LOCERR_CURL_LDAP_INVALID_URL

No description

LOCERR_CURL_USE_SSL_FAILED

No description

LOCERR_CURL_SSL_ENGINE_INITFAILED

No description

LOCERR_CURL_LOGIN_DENIED

No description

LOCERR_CURL_TFTP_NOTFOUND

No description

LOCERR_CURL_TFTP_ILLEGAL

No description

LOCERR_CURL_SSH

No description

LOCERR_SETEXPRESSION_TOO_LARGE

No description

LOCERR_RELOAD_MERGE_LOAD_ERROR

No description

LOCERR_WIN_FTP_DROPPED

No description

LOCERR_WIN_FTP_NO_PASSIVE_MODE

No description

LOCERR_WIN_HTTP_DOWNLEVEL_SERVER

No description

LOCERR_WIN_HTTP_INVALID_SERVER_RESPONSE

No description

LOCERR_WIN_HTTP_REDIRECT_NEEDS_CONFIRMATION

No description

LOCERR_WIN_INTERNET_FORCE_RETRY

No description

LOCERR_WIN_INTERNET_CANNOT_CONNECT

No description

LOCERR_WIN_INTERNET_CONNECTION_ABORTED

No description

LOCERR_WIN_INTERNET_CONNECTION_RESET

No description

LOCERR_WIN_INTERNET_DISCONNECTED

No description

LOCERR_WIN_INTERNET_INCORRECT_FORMAT

No description

LOCERR_WIN_INTERNET_INVALID_CA

No description

LOCERR_WIN_INTERNET_INVALID_OPERATION

No description

LOCERR_WIN_INTERNET_INVALID_URL

No description

LOCERR_WIN_INTERNET_ITEM_NOT_FOUND

No description

LOCERR_WIN_INTERNET_LOGIN_FAILURE

No description

LOCERR_WIN_INTERNET_NAME_NOT_RESOLVED

No description

LOCERR_WIN_INTERNET_NEED_UI

No description

LOCERR_WIN_INTERNET_SEC_CERT_CN_INVALID

No description

LOCERR_WIN_INTERNET_SEC_CERT_DATE_INVALID

No description

LOCERR_WIN_INTERNET_SEC_CERT_ERRORS

No description

LOCERR_WIN_INTERNET_SEC_INVALID_CERT

No description

LOCERR_WIN_INTERNET_SERVER_UNREACHABLE

No description

schemasNxLocalizedWarningCode

string

oneOf

LOCWARN_PERSONAL_RELOAD_REQUIRED

No description

LOCWARN_PERSONAL_VERSION_EXPIRES_SOON

No description

LOCWARN_EXPORT_DATA_TRUNCATED

No description

LOCWARN_COULD_NOT_OPEN_ALL_OBJECTS

No description

LOCWARN_SEARCH_INVALID_SEARCHFIELD_DETECTED

No description

schemasNxMatchingFieldInfo

object

Properties

qName
string

Name of the field.

qTags
Array<string>

List of tags.

schemasNxMatchingFieldMode

string

oneOf

MATCHINGFIELDMODE_MATCH_ALL

No description

MATCHINGFIELDMODE_MATCH_ONE

No description

schemasNxMeasure

object
Either **qDef** or **qLibraryId** must be set, but not both.
If the measure is set in the hypercube and not in the library, this measure cannot be shared with other objects.
A measure that is set in the library can be used by many objects.
expressions are complementary expressions associated to a measure. For example, you can decide to change the background color of a visualization depending on the values of the measure. Attribute expressions do not affect the layout of an object. The sorting order is unchanged.

Properties

qLibraryId
string

Refers to a measure stored in the library.

qDef

No description

qSortBy

No description

qAttributeExpressions

List of attribute expressions.

qAttributeDimensions

List of attribute dimensions.

qCalcCond

No description

qCalcCondition

No description

qTrendLines

Specifies trendlines for this measure.

qMiniChartDef

No description

schemasNxMeasureInfo

object

Layout for NxInlineMeasureDef.

Properties

qFallbackTitle
string

Corresponds to the label of the measure. If the label is not defined then the measure name is used.

qApprMaxGlyphCount
integer<int32>

Length of the longest value in the field.

qCardinal
integer<int32>

Number of distinct field values.

qSortIndicator

No description

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qMin
number<double>

Lowest value in the range.

qMax
number<double>

Highest value in the range.

qError

No description

qReverseSort
boolean

If set to true, it inverts the sort criteria in the field.

qIsAutoFormat
boolean

This parameter is set to true if qNumFormat is set to U (unknown). The engine guesses the type of the field based on the field's expression.

qAttrExprInfo

List of attribute expressions.

qAttrDimInfo

List of attribute dimensions.

qCalcCondMsg
string

The message displayed if calculation condition is not fulfilled.

qLibraryId
string

Refers to a dimension stored in the library.

qTrendLines

Calculated trendlines

qMiniChart

No description

schemasNxMeta

object

Layout for NxMetaDef.

Properties

qName
string

Name. This property is optional.

schemasNxMetaDef

object

Used to collect meta data.

Properties

Semantic type with an empty structure.

schemasNxMiniChart

object

Properties

qYMin
number<double>

No description

qYMax
number<double>

No description

qXMin
number<double>

No description

qXMax
number<double>

No description

qAttrExprInfo

List of attribute expressions.

qError

No description

schemasNxMiniChartCell

object

Properties

qText
string

Some text.

qNum
number<double>

A value. This parameter is optional.

qElemNumber
integer<int32>

Rank number of the value, starting from 0. If the element number is a negative number, it means that the returned value is not an element number. You can get the following negative values:

  • -1: the cell is a Total cell. It shows a total.
  • -2: the cell is a Null cell.
  • -3: the cell belongs to the group Others .
  • -4: the cell is empty. Applies to pivot tables.
qAttrExps

No description

schemasNxMiniChartData

object

Properties

qMatrix
Array<Array<NxMiniChartCell>>

Array of data.

qMin
number<double>

No description

qMax
number<double>

No description

qError

No description

schemasNxMiniChartDef

object

Properties

qDef
string

Expression or field name.

qLibraryId
string

LibraryId for dimension.

qSortBy

No description

qOtherTotalSpec

No description

qMaxNumberPoints
default=-1
integer<int32>

No description

qAttributeExpressions

List of attribute expressions.

qNullSuppression
boolean

If set to true, no null values are returned.

schemasNxMiniChartRows

Array<NxMiniChartCell>

schemasNxMultiRangeSelectInfo

object

Properties

qRanges

No description

qColumnsToSelect
Array<integer<int32>>

No description

schemasNxPage

object

Properties

qLeft
integer<int32>

Position from the left. Corresponds to the first column.

qTop
integer<int32>

Position from the top. Corresponds to the first row.

qWidth
integer<int32>

Number of columns in the page. The indexing of the columns may vary depending on whether the cells are expanded or not (parameter qAlwaysFullyExpanded in HyperCubeDef ).

qHeight
integer<int32>

Number of rows or elements in the page. The indexing of the rows may vary depending on whether the cells are expanded or not (parameter qAlwaysFullyExpanded in HyperCubeDef ).

schemasNxPageTreeLevel

object

Properties

qLeft
integer<int32>

The first dimension that is to be part of the tree, counted from the left. For example, if qLeft is equal to 1, omit nodes from the first dimension in the current sort order.

qDepth
default=-1
integer<int32>

Number of dimensions to include in the tree.

schemasNxPageTreeNode

object

Defines an area of the tree to be fetched.

Properties

qArea

No description

qAllValues
boolean

When set to true, generated nodes (based on current selection) will be inserted into the returned tree even when there is no actual value. For example, suppose you are looking for hybrid car sales at all car dealerships. Normally, only dealerships where hybrid cars are sold would be part of the returned tree but with qAllValues set to true, all available dealerships will be included regardless if they sold any hybrid cars or not.

schemasNxPatch

object

Properties

qOp

No description

qPath
string

Path to the property to add, remove or replace.

qValue
string

This parameter is not used in a remove operation. Corresponds to the value of the property to add or to the new value of the property to update. Examples: "false", "2", ""New title""

schemasNxPatchOperationType

string

oneOf

add

Add

remove

Remove

replace

Replace

schemasNxPatches

object

Properties

qInfo

No description

qPatches

Array with patches.

qChildren

Array with child objects and their patches.

schemasNxPivotDimensionCell

object

Properties

qText
string

Some text.

qElemNo
integer<int32>

Rank number of the value. If set to -1, it means that the value is not an element number.

qValue
number<double>

Value of the cell. Is set to NaN , if the value is not a number.

qCanExpand
boolean

If set to true, it means that the cell can be expanded. This parameter is not returned if it is set to false.

qCanCollapse
boolean

If set to true, it means that the cell can be collapsed. This parameter is not returned if it is set to false.

qType

No description

qUp
integer<int32>

Number of elements that are part of the previous tail. This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight .

qDown
integer<int32>

Number of elements that are part of the next tail. This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight .

qSubNodes

Information about sub nodes (or sub cells). The array is empty [ ] when there is no sub nodes.

qAttrExps

No description

qAttrDims

No description

schemasNxPivotPage

object

Properties

qLeft

Information about the left dimension values of a pivot table.

qTop

Information about the top dimension values of a pivot table. If there is no top dimension in the pivot table, information about the measures are given.

qData
Array<Array<NxPivotValuePoint>>

Array of data.

qArea

No description

schemasNxPivotValuePoint

object

Properties

qLabel
string

Label of the cell. This parameter is optional.

qText
string

Some text related to the cell.

qNum
number<double>

Value of the cell.

qType

No description

qAttrExps

No description

qAttrDims

No description

schemasNxRange

object

Properties

qFrom
integer<int32>

Position in the expression of the first character of the field name.

qCount
integer<int32>

Number of characters in the field name.

schemasNxRangeSelectInfo

object

Properties

qRange

No description

qMeasureIx
integer<int32>

Number of the measure to select. Numbering starts from 0.

schemasNxSelectionCell

object

Properties

qType

No description

qCol
integer<int32>

Column index to select. Indexing starts from 0. If the cell's type is:

  • D, the index is based on the data matrix.
  • T, the index is based on the data matrix.
  • L, the index is based on the left dimensions indexes.
qRow
integer<int32>

Row index to select. Indexing starts from 0. If the cell's type is:

  • D, the index is based on the data matrix.
  • T, the index is based on the top dimensions indexes.
  • L, the index is based on the data matrix.

schemasNxSelectionCellType

string

oneOf

D

NX_CELL_DATA

T

NX_CELL_TOP

L

NX_CELL_LEFT

schemasNxSelectionInfo

object

Properties

qInSelections
boolean

Is set to true if the visualization is in selection mode. For more information about the selection mode, see BeginSelections Method.

qMadeSelections
boolean

Is set to true if the visualization is in selection mode and if some selections have been made while in selection mode. For more information about the selection mode, see BeginSelections Method.

schemasNxSimpleDimValue

object

Properties

qText
string

Text related to the attribute expression value. This property is optional. No text is returned if the attribute expression value is a numeric.

qElemNo
integer<int32>

Element number.

schemasNxSimpleValue

object

Properties

qText
string

Text related to the attribute expression value.

qNum
number<double>

Numeric value of the attribute expression. Set to NaN (Not a Number) if the attribute expression value is not numeric.

schemasNxSortIndicatorType

string

oneOf

N

NX_SORT_INDICATE_NONE

A

NX_SORT_INDICATE_ASC

D

NX_SORT_INDICATE_DESC

schemasNxStackPage

object

Properties

qData

Array of data.

qArea

No description

schemasNxStackedPivotCell

object

Properties

qText
string

Some text.

qElemNo
integer<int32>

Rank number of the value. If set to -1, it means that the value is not an element number.

qValue
number<double>

Value of the cell. Is set to NaN , if the value is not a number.

qCanExpand
boolean

If set to true, it means that the cell can be expanded. This parameter is not returned if it is set to false.

qCanCollapse
boolean

If set to true, it means that the cell can be collapsed. This parameter is not returned if it is set to false.

qType

No description

qMaxPos
number<double>

Total of the positive values in the current group of cells.

qMinNeg
number<double>

Total of the negative values in the current group of cells.

qUp
integer<int32>

Number of elements that are part of the previous tail.

qDown
integer<int32>

Number of elements that are part of the next tail.

qRow
integer<int32>

Row index in the data matrix. The indexing starts from 0.

qSubNodes

Information about sub nodes (or sub cells). The array is empty [ ] when there are no sub nodes.

qAttrExps

No description

qAttrDims

No description

schemasNxStateCounts

object

Properties

qLocked
integer<int32>

Number of values in locked state.

qSelected
integer<int32>

Number of values in selected state.

qOption
integer<int32>

Number of values in optional state.

qDeselected
integer<int32>

Number of values in deselected state.

qAlternative
integer<int32>

Number of values in alternative state.

qExcluded
integer<int32>

Number of values in excluded state.

qSelectedExcluded
integer<int32>

Number of values in selected excluded state.

qLockedExcluded
integer<int32>

Number of values in locked excluded state.

schemasNxStreamListEntry

object
deprecated
This struct is deprecated (not recommended to use).

Properties

qName
string

Name of the stream.

qId
string

Identifier of the stream.

schemasNxTempBookmarkOptions

object
experimental

Properties

qIncludeVariables
boolean

IncludeVariables If true all variables will be stored in the temporary bookmark

qIncludeAllPatches
boolean

IncludeAllPatches If true all patches will be stored in the temporary bookmark, if false ObjectIdsToPatch will determine what patches to include

schemasNxTickCell

object

Properties

qText
string

Tick's label.

qStart
number<double>

Start value.

qEnd
number<double>

End value.

schemasNxTreeDataOption

object

Specifies all the paging filters needed to define the tree to be fetched.

Properties

qMaxNbrOfNodes
integer<int32>

Maximum number of nodes in the tree. If this limit is exceeded, no nodes are returned. All nodes are counted.

qTreeNodes

Defines areas of the tree to be fetched. Areas must be defined left to right.

qTreeLevels

No description

schemasNxTreeDimensionDef

object

Properties

qLibraryId
string

Refers to a dimension stored in the library.

qDef

No description

qValueExprs

List of measures.

qNullSuppression
boolean

If set to true, no null values are returned.

qOtherTotalSpec

No description

qShowAll
boolean

If set to true, all dimension values are shown.

qOtherLabel

No description

qTotalLabel

No description

qCalcCondition

No description

qAttributeExpressions

List of attribute expressions.

qAttributeDimensions

List of attribute dimensions.

schemasNxTreeDimensionInfo

object

Properties

qFallbackTitle
string

Corresponds to the label of the dimension that is selected. If the label is not defined then the field name is used.

qApprMaxGlyphCount
integer<int32>

Length of the longest value in the field.

qCardinal
deprecated
integer<int32>

Number of distinct field values.

qLocked
boolean

Is set to true if the field is locked.

qSortIndicator

No description

qGroupFallbackTitles
Array<string>

Array of dimension labels. Contains the labels of all dimensions in a hierarchy group (for example the labels of all dimensions in a drill down group).

qGroupPos
integer<int32>

Index of the dimension that is currently in use. qGroupPos is set to 0 if there are no hierarchical groups (drill-down groups) or cycle groups.

qStateCounts

No description

qTags
Array<string>

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

qError

No description

qDimensionType

No description

qReverseSort
boolean

If set to true, it inverts the sort criteria in the field.

qGrouping

No description

qIsSemantic
boolean

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

qNumFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qIsAutoFormat
boolean

This parameter is set to true if qNumFormat is set to U (unknown). The engine guesses the type of the field based on the field's definition.

qGroupFieldDefs
Array<string>

Array of field names.

qMin
number<double>

Minimum value.

qMax
number<double>

Maximum value.

qContinuousAxes
boolean

Is continuous axis used.

qIsCyclic
boolean

Is a cyclic dimension used.

qDerivedField
boolean

Is derived field is used as a dimension.

qMeasureInfo

A List of measures to be calculated on this TreeDimension.

qAttrExprInfo

List of attribute expressions.

qAttrDimInfo

List of attribute dimensions.

qCalcCondMsg
string

The message displayed if calculation condition is not fulfilled.

qIsCalculated
default=false
boolean

True if this is a calculated dimension.

qIsOneAndOnlyOne
boolean

If set to true, it means that the field always has one and only one selected value.

qCardinalities

No description

qLibraryId
string

Refers to a dimension stored in the library.

schemasNxTreeMultiRangeSelectInfo

object

Properties

qRanges

An array of Ranges.

schemasNxTreeNode

object

Represents a dimension in the tree.

Properties

qText
string

The text version of the value, if available.

qValue
number<double>

Value of the cell. Is set to NaN , if the value is not a number.

qElemNo
integer<int32>

Element number.

qGroupPos
integer<int32>

The position of this node inside it's group in the complete tree, i.e. Not dependant om what part is fetched.

qGroupSize
integer<int32>

Nbr of nodes connected to this node on the next level of the tree. Not dependant on what part is fetched.

qRow
integer<int32>

Row index in the data matrix. The indexing starts from 0.

qType

No description

qValues

The measures for this node.

qNodes

The children of this node in the fetched tree structure.

qAttrExps

No description

qAttrDims

No description

qMaxPos
Array<number<double>>

Total of the positive values in the current group of cells.

qMinNeg
Array<number<double>>

Total of the negative values in the current group of cells.

qCanExpand
boolean

If set to true, it means that the cell can be expanded. This parameter is not returned if it is set to false.

qCanCollapse
boolean

If set to true, it means that the cell can be collapsed. This parameter is not returned if it is set to false.

qState

No description

qTreePath
Array<integer<int32>>

The GroupPos of all prior nodes connected to this one, one position for each level of the tree. If this node is attached directly to the root, this array is empty.

schemasNxTreeRangeSelectInfo

object

Properties

qRange

No description

qMeasureIx
integer<int32>

Number of the measure to select. Numbering starts from 0.

qDimensionIx
integer<int32>

Number of the dimension to select measure from. Numbering starts from 0.

schemasNxTreeValue

object

Represents a measure.

Properties

qText
string

The text version of the value, if available.

qValue
number<double>

Value of the cell. Is set to NaN , if the value is not a number.

qAttrExps

No description

qAttrDims

No description

schemasNxTrendline

object
experimental

Information about the calculated trendline.

Properties

qType

No description

qError

No description

qCoeff
Array<number<double>>

Coefficent c0..cN depending on the trendline type.

qR2
number<double>

R2 score. Value between 0..1 that shows the correlation between the trendline and the data. Higher value means higher correlation.

qExpression
string

Trendline expression

qElemNo
integer<int32>

Inner Dim elem no

schemasNxTrendlineDef

object
experimental

Trendline input definition

Properties

qType

No description

qXColIx
default=-1
integer<int32>

The column in the hypercube to be used as x axis. Can point to either a dimension (numeric or text) or a measure

qCalcR2
default=false
boolean

Set to true to calulatate the R2 score

qContinuousXAxis

No description

qMultiDimMode

No description

schemasNxTrendlineMode

string

oneOf

Multi

TRENDLINE_MULTILINE

Sum

TRENDLINE_SUM

schemasNxValidationError

object

Properties

qErrorCode
integer<int32>

Error code. This parameter is always displayed in case of error.

qContext
string

Context related to the error, from the user app domain. It can be the identifier of an object, a field name, a table name. This parameter is optional.

qExtendedMessage
string

Internal information from the server. This parameter is optional.

schemasNxVariableListItem

object

Properties

qName
string

Name of the variable.

qDescription
string

Description of the variable.

qDefinition
string

Definition of the variable. It can be a value or an expression.

qIsConfig
default=false
boolean

If set to true, it means that the variable is a system variable. A system variable provides information about the system and is set by the engine. The content cannot be changed by the user. This parameter is optional. The default value is false.

qIsReserved
default=false
boolean

If set to true, it means that the variable is reserved. The default value is false. This parameter is optional. Examples:

  • ScriptError is a reserved variable, set by the engine.
  • DayNames is a reserved variable, set by the user.
qMeta

Layout for NxMetaDef.

qInfo

No description

qData

Contains dynamic JSON data specified by the client.

qIsScriptCreated
boolean

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

schemasNxVariableProperties

object
deprecated

Properties

qName
string

Name of the variable.

qNumberPresentation

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qIncludeInBookmark
default=false
boolean

Set this property to true to update the variable when applying a bookmark. The value of a variable can affect the state of the selections. The default value is false.

qUsePredefListedValues
boolean

The value of a variable can be an enumeration. Set this property to true to reflect the predefined values in an enumeration.

qPreDefinedList
Array<string>

List of enumerations. This property is used if qUsePredefListedValues is set to true.

schemasNxViewPort

object

Properties

qWidth
integer<int32>

Width of the canvas in pixels.

qHeight
integer<int32>

Height of the canvas in pixels.

qZoomLevel
integer<int32>

Zoom level.

schemasObjectInterface

object

Properties

qType
string

The native type of the object.

qHandle
integer<int32>

The handle used to connect to object.

qGenericType
string

The type of the object.

qGenericId
string

Object ID.

schemasOdbcDsn

object

Properties

qName
string

Name of the ODBC connection.

qDescription
string

Description of the ODBC connection.

qBit32
default=false
boolean

Is set to true if the version of ODBC is 32-bit. This parameter is optional. Default is false.

qUserOnly
default=false
boolean

Is set to true if the connection is User DSN. The connection works only for a specific user. Default is false. This parameter is optional.

schemasOleDbProvider

object

Properties

qName
string

Name of the OLEDB provider.

qDescription
string

Description of the OLEDB provider.

qBit32
default=false
boolean

Is set to true if the version of the OLEDB provider is 32-bit. Default is false. This parameter is optional.

schemasOtherLimitMode

string

oneOf

OTHER_GE_LIMIT

No description

OTHER_LE_LIMIT

No description

OTHER_GT_LIMIT

No description

OTHER_LT_LIMIT

No description

schemasOtherMode

string

oneOf

OTHER_OFF

No description

OTHER_COUNTED

No description

OTHER_ABS_LIMITED

No description

OTHER_ABS_ACC_TARGET

No description

OTHER_REL_LIMITED

No description

OTHER_REL_ACC_TARGET

No description

schemasOtherSortMode

string

oneOf

OTHER_SORT_DEFAULT

No description

OTHER_SORT_DESCENDING

No description

OTHER_SORT_ASCENDING

No description

schemasOtherTotalSpecProp

object

Properties

qOtherMode

No description

qOtherCounted

No description

qOtherLimit

No description

qOtherLimitMode

No description

qSuppressOther
default=false
boolean

If set to true, the group Others is not displayed as a dimension value. The default value is false.

qForceBadValueKeeping
default=true
boolean

This parameter is used when qOtherMode is set to:

  • OTHER_ABS_LIMITED
  • OTHER_REL_LIMITED
  • OTHER_ABS_ACC_TARGET OTHER_REL_ACC_TARGET

and when the dimension values include not numeric values. Set this parameter to true to include text values in the returned values. The default value is true.

qApplyEvenWhenPossiblyWrongResult
default=true
boolean

Set this parameter to true to allow the calculation of Others even if the engine detects some potential mistakes. For example the country Russia is part of the continent Europe and Asia. If you have an hypercube with two dimensions Country and Continent and one measure Population, the engine can detect that the population of Russia is included in both the continent Asia and Europe. The default value is true.

qGlobalOtherGrouping
default=false
boolean

This parameter applies to inner dimensions. If this parameter is set to true, the restrictions are calculated on the selected dimension only. All previous dimensions are ignored. The default value is false.

qOtherCollapseInnerDimensions
default=false
boolean

If set to true, it collapses the inner dimensions (if any) in the group Others . The default value is false.

qOtherSortMode

No description

qTotalMode

No description

qReferencedExpression

No description

schemasPoint

object

Properties

qx
integer<int32>

x-coordinate in pixels. The origin is the top left of the screen.

qy
integer<int32>

y-coordinate in pixels. The origin is the top left of the screen.

schemasPositionMark

object

Properties

qDimName
string

No description

qElemNo
Array<integer<int32>>

No description

qElemValues
Array<Array<integer<byte>>>

No description

schemasProgressData

object

Properties

qStarted
boolean

True if the request is started.

qFinished
boolean

True if the request is finished.

qCompleted
integer<int64>

This property is not used.

qTotal
integer<int64>

This property is not used.

qKB
integer<int32>

This property is not used.

qMillisecs
integer<int32>

Request duration in milliseconds.

qUserInteractionWanted
boolean

True when the engine pauses the script execution and waits for a user interaction.

qPersistentProgress
string

A progress message is persistent when it informs about the start or end of a statement. For example, it can inform about the total number of lines fetched from a data source or tell that the app was saved. All persistent progress messages between two GetProgress calls are summarized in this string. Contrarily to qPersistentProgressMessages, the content of the localized message string is displayed (not its message code).

qTransientProgress
string

A progress message is transient when it informs about the progress of an ongoing statement. For example, it can tell how many lines are currently fetched from a data source. All transient progress messages between two GetProgress calls are summarized in this string. Contrarily to qTransientProgressMessage, the content of the localized message string is displayed (not its message code).

qErrorData

Information about the error messages that occur during the script execution.

qPersistentProgressMessages

List of persistent progress messages.

qTransientProgressMessage

No description

schemasProgressMessage

object

Properties

qMessageCode
integer<int32>

Code number to the corresponding localized message string.

qMessageParameters
Array<string>

Parameters to be inserted in the localized message string.

schemasRange

object

Properties

qMin
number<double>

Lowest value in the range

qMax
number<double>

Highest value in the range

qMinInclEq
boolean

If set to true, the range includes the lowest value in the range of selections (Equals to ). [bn(50500)] Example: The range is [1,10]. If qMinInclEq is set to true it means that 1 is included in the range of selections.

qMaxInclEq
boolean

If set to true, the range includes the highest value in the range of selections (Equals to ). [bn(50500)] Example: The range is [1,10]. If qMinInclEq is set to true it means that 10 is included in the range of selections.

schemasRangeSelectInfo

object

Properties

qRangeLo
default=-1e+300
number<double>

Lowest value in the range.

qRangeHi
default=-1e+300
number<double>

Highest value in the range.

qMeasure
string

Label of the measure.

schemasRect

object

Properties

qLeft
integer<int32>

Position from the left. Corresponds to the first column.

qTop
integer<int32>

Position from the top. Corresponds to the first row.

qWidth
integer<int32>

Number of columns in the page. The indexing of the columns may vary depending on whether the cells are expanded or not (parameter qAlwaysFullyExpanded in HyperCubeDef ).

qHeight
integer<int32>

Number of rows or elements in the page. The indexing of the rows may vary depending on whether the cells are expanded or not (parameter qAlwaysFullyExpanded in HyperCubeDef ).

schemasSampleResult

object

Properties

qFieldOrColumn

No description

qValues

Matched values part of the sample.

schemasScriptSyntaxError

object

Properties

qErrLen
default=0
integer<int32>

Length of the word where the error is located.

qTabIx
default=0
integer<int32>

Number of the faulty section.

qLineInTab
default=0
integer<int32>

Line number in the section where the error is located.

qColInLine
default=0
integer<int32>

Position of the erroneous text from the beginning of the line.

qTextPos
default=0
integer<int32>

Position of the erroneous text from the beginning of the script.

qSecondaryFailure
boolean

The default value is false.

schemasScrollPosition

object

Properties

qUsePosition
boolean

No description

qPos

No description

schemasSearchAssociationResult

object
deprecated

Properties

qFieldNames
Array<string>

List of the fields that contains search associations.

qSearchTerms
Array<string>

List of the search terms.

qFieldDictionaries

Information about the fields containing search hits.

qSearchTermsMatched

List of search results. The maximum number of search results in this list is set by qPage/qCount .

qTotalSearchResults
integer<int32>

Total number of search results. This number is not limited by qPage/qCount .

schemasSearchAttribute

object

Properties

qKey
string

String corresponding to SearchObjectOptions.qAttributes. It will be qProperty for SearchObjectOptions.

qValue
string

String corresponding to qKey for the current SearchGroupItemMatch. For example, if the match is Make by Price found in the title of a generic object, qValue will be qMetaDef/title.

schemasSearchCharRange

object

Properties

qCharPos
integer<int32>

Starting position of the match in the search result, starting from 0.

qCharCount
integer<int32>

Length of the match in the search result.

qTerm
integer<int32>

Position of the term in the list of search terms, starting from 0.

schemasSearchCombinationOptions

object

Properties

qSearchFields
Array<string>

List of the search fields. If empty, the search is performed in all fields of the app.

qContext

No description

qCharEncoding

No description

qAttributes
Array<string>

Optional.

  • For SearchSuggest method, this array is empty.
  • For SearchObjects method, this array is empty or contain qProperty .
  • For SearchResults method, this array is empty, or contains qNum and/or qElemNum . It allows the user to request details in the outputted SearchGroupItemMatch . For more information, see SearchGroupItemMatch.

schemasSearchContextType

string

oneOf

Cleared

CONTEXT_CLEARED

LockedFieldsOnly

CONTEXT_LOCKED_FIELDS_ONLY

CurrentSelections

CONTEXT_CURRENT_SELECTIONS

schemasSearchFieldDictionary

object
deprecated

Properties

qField
integer<int32>

Position of the field in the list of fields, starting from 0. The list of fields is defined in qResults/qFieldNames and contains the search associations.

qResult

List of the matching values. The maximum number of values in this list is set by qMaxNbrFieldMatches .

schemasSearchFieldMatch

object
deprecated

Properties

qField
integer<int32>

Position of the field in the list of fields, starting from 0. The list of fields is defined in qResults/qFieldNames and contains the search associations.

qValues
Array<integer<int64>>

Positions of the matching values in the search results. The maximum number of values in this list is defined by qMaxNbrFieldMatches .

qTerms
Array<integer<int32>>

Positions of the search terms, starting from 0.

qNoOfMatches
integer<int32>

Number of search hits in the field. The number of values in qValues and the value of qNoOfMatches are equal if qMaxNbrFieldMatches is -1.

schemasSearchFieldMatchesItem

object
experimental

Properties

qText
string

No description

qElemNo
integer<int32>

No description

qSearchTermsMatched
Array<integer<int32>>

No description

schemasSearchFieldSelectionMode

string

oneOf

OneAndOnlyOne

ONE_AND_ONLY_ONE

schemasSearchFieldValueItem

object
experimental

Properties

qFieldName
string

Field name of matches.

qValues

List of search matches.

schemasSearchGroup

object

Properties

qId
integer<int32>

Identifier of the search group.

qGroupType

No description

qSearchTermsMatched
Array<integer<int32>>

Indexes of the search terms that are included in the group. These search terms are related to the list of terms defined in SearchResult.qSearchTerms .

qTotalNumberOfItems
integer<int32>

Total number of distinct items in the search group.

qItems

List of items in the search group. The group items are numbered from the value of SearchGroupOptions.qOffset to the value of SearchGroupOptions.qOffset + SearchGroupOptions.qCount

schemasSearchGroupItem

object

Properties

qItemType

No description

qTotalNumberOfMatches
integer<int32>

Total number of distinct matches in the search group item.

qIdentifier
string

Identifier of the item. It corresponds to:

  • The name of the field, if the type of the search group is data set.
  • The id of the generic object if the type of the search group is generic object.
qItemMatches

List of matches in the search group item. The group item matches are numbered from the value of SearchGroupItemOptions.qOffset to the value of SearchGroupItemOptions.qOffset + SearchGroupItemOptions.qCount .

qSearchTermsMatched
Array<integer<int32>>

Indexes of the search terms that are included in the group item. These search terms are related to the list of terms defined in SearchResult.qSearchTerms .

schemasSearchGroupItemMatch

object

Properties

qText
string

Search match value. Value of the search group item. If the match is found in a field, it corresponds to the value of the field. If the match is found in a generic object property, it corresponds to the property value.

qFieldSelectionMode

No description

qRanges

List of ranges. For example, if the search terms are Price and Make, and the search group item value is Make by Price vs Mileage, then there are two ranges: one for Price and one for Make.

qAttributes

Provides detail of the match as requested by the user in SearchObjectsOptions.qAttributes or SearchCombinationOptions.qAttributes If the user requests SearchObjects or SearchResults with an empty qAttributes option, the outputted qAttributes is returned empty. For SearchObjects requested with qProperty , the SearchGroupItemMatch.qAttributes return value contains [“qProperty”, "qMetaDef/title”] if the match has been found in the title of the item. For dimension values, the returned qProperty will be “*” . For SearchResults requested with qNum , the SearchGroupItemMatch.qAttributes return value contains ["qNum", N] where N is the numeric value of the element or NaN if the value is not numeric. For SearchResults requested with qElemNum , the SearchGroupItemMatch.qAttributes return value contains ["qElemNum", N] where N is the value index of the element.

schemasSearchGroupItemOptions

object

Properties

qGroupItemType

No description

qOffset
default=0
integer<int32>

Position starting from 0. The default value is 0.

qCount
default=-1
integer<int32>

Maximum number of matches per item (in qItemMatches[ ] ). The default value is -1: all values are returned.

schemasSearchGroupItemType

string

oneOf

Field

FIELD

GenericObject

GENERIC_OBJECT

schemasSearchGroupOptions

object

Properties

qGroupType

No description

qOffset
default=0
integer<int32>

Position starting from 0. The default value is 0.

qCount
default=-1
integer<int32>

Maximum number of items per group (in qItems[ ] ). The default value is -1; all values are returned.

schemasSearchGroupType

string

oneOf

DatasetType

DATASET_GROUP

GenericObjectsType

GENERIC_OBJECTS_GROUP

schemasSearchMatchCombination

object
deprecated

Properties

qId
integer<int32>

Index of the search result, starting from 0.

qFieldMatches

Information about the search matches.

schemasSearchMatchCombinations

Array<SearchMatchCombination>
deprecated

schemasSearchObjectOptions

object

Properties

qAttributes
Array<string>

This array is either empty or contains qProperty .

qCharEncoding

No description

schemasSearchPage

object

Properties

qOffset
integer<int32>

Position from the top, starting from 0. If the offset is set to 0, the first search result to be returned is at position 0.

qCount
integer<int32>

Number of search groups to return (in qSearchGroupArray ).

qMaxNbrFieldMatches
default=-1
integer<int32>

Maximum number of matching values to return per search result. The default value is -1; all values are returned. This property is to be used with the SearchAssociations method.

qGroupOptions

Options of the search groups. If this property is not set, all values are returned. This property is to be used with the SearchResults method or the SearchObjects method.

qGroupItemOptions

Options of the search group items. If this property is not set, all values are returned. This property is to be used with the SearchResults method or the SearchObjects method.

schemasSearchResult

object

Properties

qSearchTerms
Array<string>

List of the search terms.

qTotalNumberOfGroups
integer<int32>

Total number of groups.

qSearchGroupArray

List of search groups. The groups are numbered from the value of SearchPage.qOffset to the value of SearchPage.qOffset + SearchPage.qCount .

schemasSearchSuggestItem

object

Properties

qValue
string

Value of the suggestion.

qTerm
integer<int32>

Index of the suggestion value. The indexing starts from 0 and from the left.

schemasSearchSuggestionResult

object

Properties

qSuggestions

List of suggestions.

qFieldNames
Array<string>

List of field names that contain search hits.

schemasSearchTermResult

object
deprecated

Properties

qText
string

Text of the associated value.

qElemNumber
integer<int32>

Element number of the associated value.

qRanges

List of ranges. For example, if the user searches the term read and the associative value is Reading , then the corresponding range would be Read in Reading .

schemasSearchValueOptions

object
experimental

Properties

qSearchFields
Array<string>

List of the search fields. If empty, the search is performed in all fields of the app.

schemasSearchValuePage

object
experimental

Properties

qOffset
integer<int32>

Position from the top, starting from 0. If the offset is set to 0, the first search result to be returned is at position 0.

qCount
integer<int32>

Number of search fields to return

qMaxNbrFieldMatches
default=-1
integer<int32>

Maximum number of matching values to return per search result.

schemasSearchValueResult

object
experimental

Properties

qSearchTerms
Array<string>

List of the search terms.

qFieldMatches

List of search groups. The groups are numbered from the value of SearchPage.qOffset to the value of SearchPage.qOffset + SearchPage.qCount .

schemasSelectInfo

object

Properties

qTextSearch
string

Text search string. Everything that matches the text is selected. This parameter is optional.

qRangeLo
default=-1e+300
number<double>

Lower value of the search range. This parameter is used when performing range selections or text searches in dimensions. Default is Null.

qRangeHi
default=-1e+300
number<double>

Highest value of the search range. This parameter is used when performing range selections or text searches in dimensions. Default is Null.

qNumberFormat

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:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

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.

qRangeInfo

This parameter is used when performing range selections or text searches in measures. Gives information about the range of selections.

qSoftLock
default=false
boolean

Set to true to ignore locks; in that case, locked fields can be selected. The default value is false.

qContinuousRangeInfo

List of information about ranges for selections.

qSelectFieldSearch
default=false
boolean

This parameter is true if the TextSearch is a result of a Select Field operation.

schemasSelectionObject

object

Indicates which selections are currently applied. It gives the current selections. Is the layout for SelectionObjectDef.

Properties

qBackCount
integer<int32>

Number of steps back.

qForwardCount
integer<int32>

Number of steps forward.

qSelections

Lists the fields that are selected.

qStateName
string

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

schemasSelectionObjectDef

object

To display the current selections. Can be added to any generic object but is particularly meaningful when using session objects to monitor an app.

Properties

"qSelectionObjectDef": {}

Properties

qStateName
string

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

schemasSize

object

Properties

qcx
integer<int32>

Number of pixels on the x axis.

qcy
integer<int32>

Number of pixels on the y axis.

schemasSortCriteria

object

Properties

qSortByState
integer<int8>

Sorts the field values according to their logical state (selected, optional, alternative or excluded).

qSortByFrequency
integer<int8>

Sorts the field values by frequency (number of occurrences in the field).

qSortByNumeric
integer<int8>

Sorts the field values by numeric value.

qSortByAscii
integer<int8>

Sorts the field by alphabetical order.

qSortByLoadOrder
integer<int8>

Sorts the field values by the initial load order.

qSortByExpression
integer<int8>

Sorts the field by expression.

qExpression

No description

qSortByGreyness
integer<int8>

No description

schemasSourceKeyRecord

object

Properties

qKeyFields
Array<string>

Name of the key field.

qTables
Array<string>

Table the key belongs to.

schemasStateEnumType

string

oneOf

L

LOCKED

S

SELECTED

O

OPTION

D

DESELECTED

A

ALTERNATIVE

X

EXCLUDED

XS

EXCL_SELECTED

XL

EXCL_LOCKED

NSTATES

No description

schemasStaticContentList

object

Properties

qItems

Information about the list of content files.

schemasStaticContentListItem

object
In addition, this structure can return dynamic properties.

Properties

qUrlDef
string

Relative path to the content file. The URL is static. In Qlik Sense Enterprise, content files located:

  • In the /content/ <content library name>/ folder are part of a global content library.
  • In the /appcontent/ folder are part of the app specific library. The content files are never embedded in the qvf file. In Qlik Sense Desktop, content files located:
  • In the /content/default/ folder are outside the qvf file.
  • In the /media/ folder are embedded in the qvf file.
qUrl
string

Relative path to the content file. The URL is static. In Qlik Sense Enterprise, content files located:

  • In the /content/ <content library name>/ folder are part of a global content library.
  • In the /appcontent/ folder are part of the app specific library. The content files are never embedded in the qvf file. In Qlik Sense Desktop, content files located:
  • In the /content/default/ folder are outside the qvf file.
  • In the /media/ folder are embedded in the qvf file.

schemasStaticContentUrl

object
In addition, this structure can return dynamic properties.

Properties

qUrl
string

Relative path of the thumbnail.

schemasStaticContentUrlDef

object
In addition, this structure can contain dynamic properties.

Properties

qUrl
string

Relative path of the thumbnail.

schemasStringExpr

object

Properties

qv
string

Expression evaluated to string.

schemasStringExpression

object

Properties

Abbreviated syntax: "qStringExpression":"=<expression>" Extended object syntax: "qStringExpression":{"qExpr":"=<expression>"} Where:

  • < expression > is a string
The "=" sign in the string expression is not mandatory. Even if the "=" sign is not given, the expression is evaluated.
A string expression is not evaluated, if the expression is surrounded by simple quotes.
The result of the evaluation of the expression can be of any type, as it is returned as a JSON (quoted) string.

Properties

qExpr
string

No description

schemasSymbolFrequency

object

Properties

qSymbol

No description

qFrequency
integer<int64>

Frequency of the above symbol in the field

schemasSymbolValue

object

Properties

qText
string

String value of the symbol. This parameter is optional and present only if Symbol is a string.

qNumber
number<double>

Numeric value of the symbol. NaN otherwise.

schemasTableProfilingData

object

Properties

qNoOfRows
integer<int64>

Number of rows in the table.

qFieldProfiling

Field values profiling info

schemasTableRecord

object

Properties

qName
string

Name of the table.

qLoose
boolean

This property is set to true if the table is loose.

qNoOfRows
integer<int64>

Number of rows in the table.

qFields

Information about the fields in the table.

qPos

No description

qComment
string

Comment related to the table.

qIsDirectDiscovery
boolean

If set to true, Direct Discovery is used. Direct Discovery fields are not loaded into memory and remain in the external database.

qIsSynthetic
boolean

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

qTableTags
Array<string>

List of tags related to the table.

qProfilingData

No description

schemasTableRow

object

Properties

qValue

Array of field values.

schemasTableViewBroomPointSaveInfo

object

Properties

qPos

No description

qTable
string

Name of the table.

qFields
Array<string>

List of fields in the table.

schemasTableViewConnectionPointSaveInfo

object

Properties

qPos

No description

qFields
Array<string>

List of the fields in the table.

schemasTableViewCtlSaveInfo

object

Properties

qInternalView

No description

qSourceView

No description

schemasTableViewDlgSaveInfo

object

Properties

qPos

No description

qCtlInfo

No description

qMode
integer<int32>

View mode to display when opening Qlik Sense data model viewer. One of:

  • 0 for internal view mode.
  • 1 for source view mode.

schemasTableViewSaveInfo

object

Properties

qTables

List of the tables in the database model viewer.

qBroomPoints

List of the broom points in the database model viewer. Not used in Qlik Sense.

qConnectionPoints

List of connection points in the database model viewer. Not used in Qlik Sense.

qZoomFactor
default=1
number<double>

Zoom factor in the database model viewer. The default value is 1.0.

schemasTableViewTableWinSaveInfo

object

Properties

qPos

No description

qCaption
string

Table name.

schemasTextMacro

object

Properties

qTag
string

Name of the variable.

qRefSeqNo
integer<int32>

Order in which the variable was referenced during the script execution. The same number sequence is used for both qRefSeqNo and qSetSeqNo .

qSetSeqNo
integer<int32>

Order in which the variable was updated during the script execution. The same number sequence is used for both qRefSeqNo and qSetSeqNo .

qDisplayString
string

Variable value.

qIsSystem
default=false
boolean

Is set to true if the variable is a system variable.

qIsReserved
default=false
boolean

Is set to true if the variable is a reserved variable.

schemasTotalMode

string

oneOf

TOTAL_OFF

No description

TOTAL_EXPR

No description

schemasTransformAppParameters

object

Properties

qName
string

The name (title) of the application

qSpaceId
string

ID of the space where the app is to be created. Empty value implies Personal space

qScriptParameterPrefix
string

Prefix to be used on inserted ScriptParameters, only applicable for template apps

schemasTransformAppResult

object

Properties

qAppId
string

ID of created App

schemasTreeData

object

Renders the properties of a TreeData object. Is the layout for TreeDataDef. For more information about the definition of TreeData, see Generic object.

To retrieve data from the TreeData object, use the method called GetHyperCubeTreeData.

Properties

qStateName
string

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

qNodesOnDim
Array<integer<int32>>

The total number of nodes on each dimension.

qError

No description

qDimensionInfo

Information on the dimension.

qEffectiveInterColumnSortOrder
Array<integer<int32>>

Defines the order of the dimenion levels/columns in the TreeData object. Column numbers are separated by a comma. Example: [1,0,2] means that the first level in the tree structure is dimension 1, followed by dimension 0 and dimension 2.

qHasOtherValues
boolean

True if other row exists.

qTitle
string

Title of the TreeData object, for example the title of a chart.

qLastExpandedPos

No description

qCalcCondMsg
string

The message displayed if calculation condition is not fulfilled.

qTreeDataPages

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

qMeasureInfo

Information on the measures calculated on the whole tree.

schemasTreeDataDef

object

Defines the properties of a TreeData object. For more information about the definition of a TreeData object, see Generic object.

Properties

qStateName
string

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

qDimensions

Array of dimensions.

qInterColumnSortOrder
Array<integer<int32>>

Defines the order of the dimension levels/columns in the TreeData object. Column numbers are separated by a comma. Example: [1,0,2] means that the first level in the tree structure is dimension 1, followed by dimension 0 and dimension 2. The default sort order is the order in which the dimensions and measures have been defined in the TreeDataDef.

qSuppressZero
default=false
boolean

Removes zero values.

qSuppressMissing
default=false
boolean

Removes missing values.

qOpenFullyExpanded
default=false
boolean

If this property is set to true, the cells are opened expanded. The default value is false.

qPopulateMissing
default=false
boolean

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.

qCalcCondition

No description

qTitle

No description

qInitialDataFetch

Initial data set. This property is optional.

qExpansionState

Expansion state per dimension.

qValueExprs

List of measures to calculate on the whole tree.

qContextSetExpression
string

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

schemasUndoInfo

object

Displays information about the number of possible undos and redos. Is the layout for UndoInfoDef.

Properties

qUndoCount
integer<int32>

Number of possible undos.

qRedoCount
integer<int32>

Number of possible redos.

schemasUndoInfoDef

object

Defines if an object should contain information on the number of possible undo and redo.

Properties

"qUndoInfoDef": {} The numbers of undos and redos are empty when an object is created. The number of possible undos is increased every time an action (for example, create a child, set some properties) on the object is performed. The number of possible redos is increased every time an undo action is performed.

schemasValueExpr

object

Properties

qv
string

Expression evaluated to dual.

schemasValueExpression

object

Properties

Abbreviated syntax: "qValueExpression":"=<expression>" Extended object syntax: "qValueExpression":{"qExpr":"=<expression>"} Where:

  • < expression > is a string.
The "=" sign in the value expression is not mandatory. Even if the "=" sign is not given, the expression is evaluated.
The expression is evaluated as a numeric.

Properties

qExpr
string

No description

schemasVariableList

object

Lists the variables in an app. Is the layout for VariableListDef.

Properties

qItems

List of the variables.

schemasVariableListDef

object

Defines the list of variables in an app.

Properties

qType
string

Type of variables to include in the list.

qShowReserved
boolean

Shows the reserved variables if set to true.

qShowConfig
boolean

Shows the system variables if set to true.

qData

Contains dynamic JSON data specified by the client.

qShowSession
boolean

Shows the session variables if set to true.

Was this page helpful?