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  |