# FieldInTableProfilingData Class

Namespace: [Qlik.Engine](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.htm)  
Assembly: Qlik.Engine.dll

## Inheritance

* System.Object
  * FieldInTableProfilingData

## Syntax

```
[ValueClass]
public class FieldInTableProfilingData : IFieldInTableProfilingData
```

## Constructors

| Name | Description |
| --- | --- |
| [FieldInTableProfilingData()](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.-ctor.htm#Qlik_Engine_FieldInTableProfilingData__ctor) |  |

## Properties

| Name | Description |
| --- | --- |
| [Average](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Average.htm#Qlik_Engine_FieldInTableProfilingData_Average) | Average of all numerical values. NaN otherwise.<br><br>JSON property name: qAverage |
| [AvgStringLen](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.AvgStringLen.htm#Qlik_Engine_FieldInTableProfilingData_AvgStringLen) | Average string length of textual values. 0 otherwise.<br><br>JSON property name: qAvgStringLen |
| [DistinctNumericValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.DistinctNumericValues.htm#Qlik_Engine_FieldInTableProfilingData_DistinctNumericValues) | Number of distinct numeric values<br><br>JSON property name: qDistinctNumericValues |
| [DistinctTextValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.DistinctTextValues.htm#Qlik_Engine_FieldInTableProfilingData_DistinctTextValues) | Number of distinct text values<br><br>JSON property name: qDistinctTextValues |
| [DistinctValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.DistinctValues.htm#Qlik_Engine_FieldInTableProfilingData_DistinctValues) | Number of distinct values<br><br>JSON property name: qDistinctValues |
| [EmptyStrings](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.EmptyStrings.htm#Qlik_Engine_FieldInTableProfilingData_EmptyStrings) | Number of empty strings<br><br>JSON property name: qEmptyStrings |
| [FieldTags](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.FieldTags.htm#Qlik_Engine_FieldInTableProfilingData_FieldTags) | List of tags related to the field.<br><br>JSON property name: qFieldTags |
| [FirstSorted](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.FirstSorted.htm#Qlik_Engine_FieldInTableProfilingData_FirstSorted) | For textual values the first sorted string.<br><br>JSON property name: qFirstSorted |
| [Fractiles](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Fractiles.htm#Qlik_Engine_FieldInTableProfilingData_Fractiles) | The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise.<br><br>JSON property name: qFractiles |
| [FrequencyDistribution](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.FrequencyDistribution.htm#Qlik_Engine_FieldInTableProfilingData_FrequencyDistribution) | Frequency Distribution for numeric fields.<br><br>JSON property name: qFrequencyDistribution |
| [Kurtosis](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Kurtosis.htm#Qlik_Engine_FieldInTableProfilingData_Kurtosis) | Kurtosis of the numerical values. NaN otherwise.<br><br>JSON property name: qKurtosis |
| [LastSorted](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.LastSorted.htm#Qlik_Engine_FieldInTableProfilingData_LastSorted) | For textual values the last sorted string.<br><br>JSON property name: qLastSorted |
| [Max](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Max.htm#Qlik_Engine_FieldInTableProfilingData_Max) | Maximum value of numerical values. NaN otherwise.<br><br>JSON property name: qMax |
| [MaxStringLen](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.MaxStringLen.htm#Qlik_Engine_FieldInTableProfilingData_MaxStringLen) | Maximum string length of textual values. 0 otherwise.<br><br>JSON property name: qMaxStringLen |
| [Median](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Median.htm#Qlik_Engine_FieldInTableProfilingData_Median) | Median of all numerical values. NaN otherwise.<br><br>JSON property name: qMedian |
| [Min](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Min.htm#Qlik_Engine_FieldInTableProfilingData_Min) | Minimum value of numerical values. NaN otherwise.<br><br>JSON property name: qMin |
| [MinStringLen](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.MinStringLen.htm#Qlik_Engine_FieldInTableProfilingData_MinStringLen) | Minimum string length of textual values. 0 otherwise.<br><br>JSON property name: qMinStringLen |
| [MostFrequent](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.MostFrequent.htm#Qlik_Engine_FieldInTableProfilingData_MostFrequent) | Three most frequent values and their frequencies<br><br>JSON property name: qMostFrequent |
| [Name](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Name.htm#Qlik_Engine_FieldInTableProfilingData_Name) | Name of the field.<br><br>JSON property name: qName |
| [NegValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.NegValues.htm#Qlik_Engine_FieldInTableProfilingData_NegValues) | Number of negative values<br><br>JSON property name: qNegValues |
| [NullValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.NullValues.htm#Qlik_Engine_FieldInTableProfilingData_NullValues) | Number of null values<br><br>JSON property name: qNullValues |
| [NumberFormat](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.NumberFormat.htm#Qlik_Engine_FieldInTableProfilingData_NumberFormat) | JSON property name: qNumberFormat |
| [NumericValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.NumericValues.htm#Qlik_Engine_FieldInTableProfilingData_NumericValues) | Number of numeric values<br><br>JSON property name: qNumericValues |
| [PosValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.PosValues.htm#Qlik_Engine_FieldInTableProfilingData_PosValues) | Number of positive values<br><br>JSON property name: qPosValues |
| [Skewness](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Skewness.htm#Qlik_Engine_FieldInTableProfilingData_Skewness) | Skewness of the numerical values. NaN otherwise.<br><br>JSON property name: qSkewness |
| [Std](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Std.htm#Qlik_Engine_FieldInTableProfilingData_Std) | Standard deviation of numerical values. NaN otherwise.<br><br>JSON property name: qStd |
| [Sum](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Sum.htm#Qlik_Engine_FieldInTableProfilingData_Sum) | Sum of all numerical values. NaN otherwise.<br><br>JSON property name: qSum |
| [Sum2](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.Sum2.htm#Qlik_Engine_FieldInTableProfilingData_Sum2) | Squared sum of all numerical values. NaN otherwise.<br><br>JSON property name: qSum2 |
| [SumStringLen](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.SumStringLen.htm#Qlik_Engine_FieldInTableProfilingData_SumStringLen) | Sum of all characters in strings in the field<br><br>JSON property name: qSumStringLen |
| [TextValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.TextValues.htm#Qlik_Engine_FieldInTableProfilingData_TextValues) | Number of textual values<br><br>JSON property name: qTextValues |
| [ZeroValues](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.FieldInTableProfilingData.ZeroValues.htm#Qlik_Engine_FieldInTableProfilingData_ZeroValues) | Number of zero values for numerical values<br><br>JSON property name: qZeroValues |