Skip to main content Skip to complementary content
Qlik Resources

FieldInTableProfilingData

Properties

Name Description Type
qName

Name of the field.

 String
qFieldTags

List of tags related to the field.

 Array of String
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:

Information note

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.

 FieldAttributes
qDistinctValues

Number of distinct values

 Integer
qDistinctNumericValues

Number of distinct numeric values

 Integer
qDistinctTextValues

Number of distinct text values

 Integer
qNumericValues

Number of numeric values

 Integer
qNullValues

Number of null values

 Integer
qTextValues

Number of textual values

 Integer
qNegValues

Number of negative values

 Integer
qPosValues

Number of positive values

 Integer
qZeroValues

Number of zero values for numerical values

 Integer
qSum

Sum of all numerical values. NaN otherwise.

 Number (double)
qSum2

Squared sum of all numerical values. NaN otherwise.

 Number (double)
qAverage

Average of all numerical values. NaN otherwise.

 Number (double)
qMedian

Median of all numerical values. NaN otherwise.

 Number (double)
qStd

Standard deviation of numerical values. NaN otherwise.

 Number (double)
qMin

Minimum value of numerical values. NaN otherwise.

 Number (double)
qMax

Maximum value of numerical values. NaN otherwise.

 Number (double)
qSkewness

Skewness of the numerical values. NaN otherwise.

 Number (double)
qKurtosis

Kurtosis of the numerical values. NaN otherwise.

 Number (double)
qFractiles

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

 Array of Number
qEmptyStrings

Number of empty strings

 Integer
qMaxStringLen

Maximum string length of textual values. 0 otherwise.

 Integer
qMinStringLen

Minimum string length of textual values. 0 otherwise.

 Integer
qSumStringLen

Sum of all characters in strings in the field

 Integer
qAvgStringLen

Average string length of textual values. 0 otherwise.

 Number (double)
qFirstSorted

For textual values the first sorted string.

 String
qLastSorted

For textual values the last sorted string.

 String
qMostFrequent

Three most frequent values and their frequencies

 Array of SymbolFrequency
qFrequencyDistribution FrequencyDistributionData

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here