# 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](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/EngineJSONAPI/Content/models-fieldattributes.htm) |
| 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](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/EngineJSONAPI/Content/models-symbolfrequency.htm) |
| qFrequencyDistribution | | [FrequencyDistributionData](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/EngineJSONAPI/Content/models-frequencydistributiondata.htm) |