# IFieldInTableProfilingData Interface
Namespace: [Qlik.Engine](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.htm)
Assembly: Qlik.Engine.dll
## Syntax
```
[ValueClass]
public interface IFieldInTableProfilingData
```
## Properties
| Name | Description |
| --- | --- |
| [Average](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Average.htm#Qlik_Engine_IFieldInTableProfilingData_Average) | Average of all numerical values. NaN otherwise.
JSON property name: qAverage |
| [AvgStringLen](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.AvgStringLen.htm#Qlik_Engine_IFieldInTableProfilingData_AvgStringLen) | Average string length of textual values. 0 otherwise.
JSON property name: qAvgStringLen |
| [DistinctNumericValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.DistinctNumericValues.htm#Qlik_Engine_IFieldInTableProfilingData_DistinctNumericValues) | Number of distinct numeric values
JSON property name: qDistinctNumericValues |
| [DistinctTextValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.DistinctTextValues.htm#Qlik_Engine_IFieldInTableProfilingData_DistinctTextValues) | Number of distinct text values
JSON property name: qDistinctTextValues |
| [DistinctValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.DistinctValues.htm#Qlik_Engine_IFieldInTableProfilingData_DistinctValues) | Number of distinct values
JSON property name: qDistinctValues |
| [EmptyStrings](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.EmptyStrings.htm#Qlik_Engine_IFieldInTableProfilingData_EmptyStrings) | Number of empty strings
JSON property name: qEmptyStrings |
| [FieldTags](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.FieldTags.htm#Qlik_Engine_IFieldInTableProfilingData_FieldTags) | List of tags related to the field.
JSON property name: qFieldTags |
| [FirstSorted](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.FirstSorted.htm#Qlik_Engine_IFieldInTableProfilingData_FirstSorted) | For textual values the first sorted string.
JSON property name: qFirstSorted |
| [Fractiles](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Fractiles.htm#Qlik_Engine_IFieldInTableProfilingData_Fractiles) | The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise.
JSON property name: qFractiles |
| [FrequencyDistribution](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.FrequencyDistribution.htm#Qlik_Engine_IFieldInTableProfilingData_FrequencyDistribution) | Frequency Distribution for numeric fields.
JSON property name: qFrequencyDistribution |
| [Kurtosis](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Kurtosis.htm#Qlik_Engine_IFieldInTableProfilingData_Kurtosis) | Kurtosis of the numerical values. NaN otherwise.
JSON property name: qKurtosis |
| [LastSorted](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.LastSorted.htm#Qlik_Engine_IFieldInTableProfilingData_LastSorted) | For textual values the last sorted string.
JSON property name: qLastSorted |
| [Max](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Max.htm#Qlik_Engine_IFieldInTableProfilingData_Max) | Maximum value of numerical values. NaN otherwise.
JSON property name: qMax |
| [MaxStringLen](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.MaxStringLen.htm#Qlik_Engine_IFieldInTableProfilingData_MaxStringLen) | Maximum string length of textual values. 0 otherwise.
JSON property name: qMaxStringLen |
| [Median](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Median.htm#Qlik_Engine_IFieldInTableProfilingData_Median) | Median of all numerical values. NaN otherwise.
JSON property name: qMedian |
| [Min](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Min.htm#Qlik_Engine_IFieldInTableProfilingData_Min) | Minimum value of numerical values. NaN otherwise.
JSON property name: qMin |
| [MinStringLen](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.MinStringLen.htm#Qlik_Engine_IFieldInTableProfilingData_MinStringLen) | Minimum string length of textual values. 0 otherwise.
JSON property name: qMinStringLen |
| [MostFrequent](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.MostFrequent.htm#Qlik_Engine_IFieldInTableProfilingData_MostFrequent) | Three most frequent values and their frequencies
JSON property name: qMostFrequent |
| [Name](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Name.htm#Qlik_Engine_IFieldInTableProfilingData_Name) | Name of the field.
JSON property name: qName |
| [NegValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.NegValues.htm#Qlik_Engine_IFieldInTableProfilingData_NegValues) | Number of negative values
JSON property name: qNegValues |
| [NullValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.NullValues.htm#Qlik_Engine_IFieldInTableProfilingData_NullValues) | Number of null values
JSON property name: qNullValues |
| [NumberFormat](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.NumberFormat.htm#Qlik_Engine_IFieldInTableProfilingData_NumberFormat) | JSON property name: qNumberFormat |
| [NumericValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.NumericValues.htm#Qlik_Engine_IFieldInTableProfilingData_NumericValues) | Number of numeric values
JSON property name: qNumericValues |
| [PosValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.PosValues.htm#Qlik_Engine_IFieldInTableProfilingData_PosValues) | Number of positive values
JSON property name: qPosValues |
| [Skewness](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Skewness.htm#Qlik_Engine_IFieldInTableProfilingData_Skewness) | Skewness of the numerical values. NaN otherwise.
JSON property name: qSkewness |
| [Std](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Std.htm#Qlik_Engine_IFieldInTableProfilingData_Std) | Standard deviation of numerical values. NaN otherwise.
JSON property name: qStd |
| [Sum](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Sum.htm#Qlik_Engine_IFieldInTableProfilingData_Sum) | Sum of all numerical values. NaN otherwise.
JSON property name: qSum |
| [Sum2](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.Sum2.htm#Qlik_Engine_IFieldInTableProfilingData_Sum2) | Squared sum of all numerical values. NaN otherwise.
JSON property name: qSum2 |
| [SumStringLen](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.SumStringLen.htm#Qlik_Engine_IFieldInTableProfilingData_SumStringLen) | Sum of all characters in strings in the field
JSON property name: qSumStringLen |
| [TextValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.TextValues.htm#Qlik_Engine_IFieldInTableProfilingData_TextValues) | Number of textual values
JSON property name: qTextValues |
| [ZeroValues](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IFieldInTableProfilingData.ZeroValues.htm#Qlik_Engine_IFieldInTableProfilingData_ZeroValues) | Number of zero values for numerical values
JSON property name: qZeroValues |