IFieldInTableProfilingData Interface
Assembly: Qlik.Engine.dll
Syntax
[ValueClass]
public interface IFieldInTableProfilingDataProperties
| 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 |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!