Skip to main content Skip to complementary content

IFieldInTableProfilingData Interface

Namespace: Qlik.Engine
Assembly: Qlik.Engine.dll

Syntax

[ValueClass]
public interface IFieldInTableProfilingData

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

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!