# Counter aggregation functions

Counter aggregation functions return various types of counts of an expression over a number of records in a 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 load script

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/count.htm)([**count**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/count.htm)**count**count([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/MissingCount.htm)([**MissingCount**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/MissingCount.htm)**MissingCount**MissingCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NullCount.htm)([**NullCount**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NullCount.htm)**NullCount**NullCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NumericCount.htm)([**NumericCount**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NumericCount.htm)**NumericCount**NumericCount([ distinctdistinct ] expression ] expression))

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/TextCount.htm)([**TextCount**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/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/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/count.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/missingcount.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/nullcount.htm)([{SetExpression}][DISTINCT] [TOTAL [<fld {,fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/numericcount.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/textcount.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)