# Counter aggregation functions

Counter aggregation functions return various types of counts of an expression over a number of records in a data load script or a number of values in a chart dimension.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

## Counter aggregation functions in the data load script

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### Count

Count() returns the number of values aggregated in expression, as defined by a group by clause.

[**count**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/count.htm)([**count**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/count.htm)**count**count([distinctdistinct ] expression ] expression | \* ))

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### MissingCount

MissingCount() returns the number of missing values aggregated in the expression, as defined by a group by clause.

[**MissingCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/MissingCount.htm)([**MissingCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/MissingCount.htm)**MissingCount**MissingCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### NullCount

NullCount() returns the number of NULL values aggregated in the expression, as defined by a group by clause.

[**NullCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/NullCount.htm)([**NullCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/NullCount.htm)**NullCount**NullCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### NumericCount

NumericCount() returns the number of numeric values found in the expression, as defined by a group by clause.

[**NumericCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/NumericCount.htm)([**NumericCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/NumericCount.htm)**NumericCount**NumericCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### TextCount

TextCount() returns the number of field values that are non-numeric aggregated in the expression, as defined by a group by clause.

[**TextCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/TextCount.htm)([**TextCount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/TextCount.htm)**TextCount**TextCount([ distinctdistinct ] expression ] expression))

## Counter aggregation functions in chart expressions

The following counter aggregation functions can be used in charts.

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### Count

Count() is used to aggregate the number of values, text and numeric, in each chart dimension.

[**count**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/CounterAggregationFunctions/count.htm)({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]]} expr)

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### MissingCount

MissingCount() is used to aggregate the number of missing values in each chart dimension. Missing values are all non-numeric values.

[**missingcount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/CounterAggregationFunctions/missingcount.htm)({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### NullCount

NullCount() is used to aggregate the number of null values in each chart dimension.

[**nullcount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/CounterAggregationFunctions/nullcount.htm)({[SetExpression][DISTINCT] [TOTAL [<fld {,fld}>]]} expr)

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### NumericCount

NumericCount() aggregates the number of numeric values in each chart dimension.

[**numericcount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/CounterAggregationFunctions/numericcount.htm)({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]]} expr)

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### TextCount

TextCount() is used to aggregate the number of field values that are non-numeric in each chart dimension.

[**textcount**](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/CounterAggregationFunctions/textcount.htm)({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]]} expr)