# Räkneaggregeringsfunktioner

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

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

## Räkneaggregeringsfunktioner i dataladdningsskriptet

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

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

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

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

[**TextCount**](https://help.qlik.com/sv-SE/sense/May2026/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterAggregationFunctions/TextCount.htm)([**TextCount**](https://help.qlik.com/sv-SE/sense/May2026/Subsystems/Hub/Content/Sense_Hub/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/sense/Subsystems/Hub/Content/Sense_Hub/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/sense/May2026/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() 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/sense/May2026/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() används för att aggregera antalet null-värden i varje diagramdimension.

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

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

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