FieldInTableProfilingData Class
Assembly: Qlik.Engine.dll
Inheritance
- 
      System.Object
      - FieldInTableProfilingData
 
Syntax
[ValueClass]
public class FieldInTableProfilingData : IFieldInTableProfilingDataConstructors
| Name | Description | 
|---|---|
| FieldInTableProfilingData() | 
Properties
| Name | Description | 
|---|---|
| Average | Average of all numerical values. NaN otherwise. JSON property name: qAverage | 
| AvgStringLen | Average string length of textual values. 0 otherwise. JSON property name: qAvgStringLen | 
| DistinctNumericValues | Number of distinct numeric values JSON property name: qDistinctNumericValues | 
| DistinctTextValues | Number of distinct text values JSON property name: qDistinctTextValues | 
| DistinctValues | Number of distinct values JSON property name: qDistinctValues | 
| EmptyStrings | Number of empty strings JSON property name: qEmptyStrings | 
| FieldTags | List of tags related to the field. JSON property name: qFieldTags | 
| FirstSorted | For textual values the first sorted string. JSON property name: qFirstSorted | 
| Fractiles | The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise. JSON property name: qFractiles | 
| FrequencyDistribution | Frequency Distribution for numeric fields. JSON property name: qFrequencyDistribution | 
| Kurtosis | Kurtosis of the numerical values. NaN otherwise. JSON property name: qKurtosis | 
| LastSorted | For textual values the last sorted string. JSON property name: qLastSorted | 
| Max | Maximum value of numerical values. NaN otherwise. JSON property name: qMax | 
| MaxStringLen | Maximum string length of textual values. 0 otherwise. JSON property name: qMaxStringLen | 
| Median | Median of all numerical values. NaN otherwise. JSON property name: qMedian | 
| Min | Minimum value of numerical values. NaN otherwise. JSON property name: qMin | 
| MinStringLen | Minimum string length of textual values. 0 otherwise. JSON property name: qMinStringLen | 
| MostFrequent | Three most frequent values and their frequencies JSON property name: qMostFrequent | 
| Name | Name of the field. JSON property name: qName | 
| NegValues | Number of negative values JSON property name: qNegValues | 
| NullValues | Number of null values JSON property name: qNullValues | 
| NumberFormat | JSON property name: qNumberFormat | 
| NumericValues | Number of numeric values JSON property name: qNumericValues | 
| PosValues | Number of positive values JSON property name: qPosValues | 
| Skewness | Skewness of the numerical values. NaN otherwise. JSON property name: qSkewness | 
| Std | Standard deviation of numerical values. NaN otherwise. JSON property name: qStd | 
| Sum | Sum of all numerical values. NaN otherwise. JSON property name: qSum | 
| Sum2 | Squared sum of all numerical values. NaN otherwise. JSON property name: qSum2 | 
| SumStringLen | Sum of all characters in strings in the field JSON property name: qSumStringLen | 
| TextValues | Number of textual values JSON property name: qTextValues | 
| ZeroValues | Number of zero values for numerical values JSON property name: qZeroValues |