Qlik Sense Engine (qix)
Variable
Sets the value of a dual variable overriding any input constraints.
Parameters
- qs stringRequired
String representation of a dual value. Set this parameter to "", if the string representation is to be Null.
- qd numberRequired
Numeric representation of a dual value.
Response
objectErrors
arrayForceContent(qs, qd)
const result = await variable.forceContent("value", 123)Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "ForceContent", "params": { "qs": "value", "qd": 123 }}Response
{ "jsonrpc": "2.0", "id": 1, "result": {}}Returns the calculated value of a variable.
Response
- qContent object Deprecated
qContent properties
- qString string
Calculated value.
- qIsNum boolean
Is set to true if the value is a numeric.
-
Errors
arrayGetContent()
const result = await variable.getContent()Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "GetContent"}Response
{ "jsonrpc": "2.0", "id": 1, "result": { "qContent": { "qString": "value", "qIsNum": true } }}Gets the properties of a variable.
Response
- qProperties object Deprecated
qProperties properties
- qName string
Name of the variable.
- qNumberPresentation 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.
qNumberPresentation properties
- qType string
Can be one of: "U""A""I""R""F""M""D""T""TS""IV"
- qnDec integer
Number of decimals. Default is 10.
- qUseThou integer
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: ,
- qIncludeInBookmark 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 of strings
List of enumerations. This property is used if qUsePredefListedValues is set to true.
-
Errors
arrayGetNxProperties()
const result = await variable.getNxProperties()Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "GetNxProperties"}Response
{ "jsonrpc": "2.0", "id": 1, "result": { "qProperties": { "qName": "value", "qNumberPresentation": { "qType": "U", "qnDec": 10, "qUseThou": 0, "qFmt": "value", "qDec": "value", "qThou": "value" }, "qIncludeInBookmark": false, "qUsePredefListedValues": true, "qPreDefinedList": [ "value" ] } }}GetRawContent()
const result = await variable.getRawContent()Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "GetRawContent"}Response
{ "jsonrpc": "2.0", "id": 1, "result": { "qReturn": "value" }}Sets a value to a variable.
Parameters
- qContent stringRequired
Value of the variable.
- qUpdateMRU booleanRequired
If set to true, the value is added to the Most Recently Used (MRU) list.
Response
- qReturn boolean
Errors
arraySetContent(qContent, qUpdateMRU)
const result = await variable.setContent("value", true)Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "SetContent", "params": { "qContent": "value", "qUpdateMRU": true }}Response
{ "jsonrpc": "2.0", "id": 1, "result": { "qReturn": true }}Sets some properties to a variable.
Parameters
- qProperties object DeprecatedRequired
Information about the properties of the variable
qProperties properties
- qName string
Name of the variable.
- qNumberPresentation 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.
qNumberPresentation properties
- qType string
Can be one of: "U""A""I""R""F""M""D""T""TS""IV"
- qnDec integer
Number of decimals. Default is 10.
- qUseThou integer
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: ,
- qIncludeInBookmark 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 of strings
List of enumerations. This property is used if qUsePredefListedValues is set to true.
-
Response
objectErrors
arraySetNxProperties(qProperties)
const result = await variable.setNxProperties({ "qName": "value", "qNumberPresentation": { "qType": "U", "qnDec": 10, "qUseThou": 0, "qFmt": "value", "qDec": "value", "qThou": "value" }, "qIncludeInBookmark": false, "qUsePredefListedValues": true, "qPreDefinedList": [ "value" ]})Request
{ "jsonrpc": "2.0", "id": 1, "handle": 3, "method": "SetNxProperties", "params": { "qProperties": { "qName": "value", "qNumberPresentation": { "qType": "U", "qnDec": 10, "qUseThou": 0, "qFmt": "value", "qDec": "value", "qThou": "value" }, "qIncludeInBookmark": false, "qUsePredefListedValues": true, "qPreDefinedList": [ "value" ] } }}Response
{ "jsonrpc": "2.0", "id": 1, "result": {}}