# Räkneaggregeringsfunktioner

Räkneaggregeringsfunktioner returnerar olika slags beräkningar av ett uttryck över ett antal poster i ett laddningsskript eller ett antal värden i en diagramdimension.

Använd listrutan för varje funktion för att visa en kort beskrivning och syntax för varje funktion. Klicka på funktionens namn i syntaxbeskrivningen för fler detaljer.

## Räkneaggregeringsfunktioner i laddningsskriptet

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### Count

Count() returnerar summan av-värden aggregerade i uttrycket, som definieras av en group by-sats.

[**count**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/count.htm)([**count**](https://help.qlik.com/sv-SE/qlikview/May2024/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() returnerar summan av-saknade värden aggregerade i uttrycket, som definieras av en group by-sats.

[**MissingCount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/MissingCount.htm)([**MissingCount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() returnerar summan av NULL-värden aggregerade i uttrycket, som definieras av en group by-sats.

[**NullCount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NullCount.htm)([**NullCount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() returnerar summan av-numeriska värden aggregerade i uttrycket, som definieras av en group by-sats.

[**NumericCount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/NumericCount.htm)([**NumericCount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() returnerar antalet fältvärden som är icke-numeriska aggregerade i uttrycket, som definieras av en group by-sats.

[**TextCount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/TextCount.htm)([**TextCount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/TextCount.htm)**TextCount**TextCount([ distinctdistinct ] expression ] expression))

## Räkneaggregeringsfunktioner i diagramuttryck

Följande räkneaggregeringsfunktioner kan användas i diagram:

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/CounterAggregationFunctions/counter-aggregation-functions.htm)

#### Count

Count() används för att aggregera antalet värden, textvärden och numeriska värden, i varje diagramdimension.

[**count**](https://help.qlik.com/sv-SE/qlikview/May2024/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() används för att aggregera antalet saknade värden i varje diagramdimension. Saknade värden är alltid icke-numeriska.

[**missingcount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() används för att aggregera antalet NULL-värden i varje diagramdimension.

[**nullcount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() aggregerar antalet numeriska värden i varje diagramdimension.

[**numericcount**](https://help.qlik.com/sv-SE/qlikview/May2024/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() används för att aggregera antalet fältvärden som är icke-numeriska i varje diagramdimension.

[**textcount**](https://help.qlik.com/sv-SE/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/textcount.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)