# 基本彙總函數

基本彙總函數是一組最常見的彙總函數。

使用各個函數的下拉式清單，查看各函數的簡短描述及語法。按一下語法描述中的函數名稱以取得更多詳細資料。

## 載入指令碼中的基本彙總函數

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

#### FirstSortedValue

排序值會在由 group by 子句所定義的若干記錄上反覆運算；若未定義 group by 子句，則會彙總完整的資料設定。

[**firstsorted**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/firstsorted.htm)([**firstsorted**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/firstsorted.htm)**firstsorted**firstsorted([ distinctdistinct ] expression , sort-weight [, n ] ] expression , sort-weight [, n ]))

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

#### Max

Max() 會找出由 group by 子句所定義的運算式中彙總資料的最大數值。透過指定 rank n，可找到第 n 個最大值。

[**max**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm)([**max**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm)**max**max( expression[, rank] expression[, rank]))

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

#### Min

Min() 會傳回由 group by 子句所定義的運算式中彙總資料的最小數值。透過指定 rank n，可找到第 n 個最小值。

[**min**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/min.htm)([**min**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/min.htm)**min**min( expression[, rank] expression[, rank]))

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

#### Mode

Mode() 會傳回由 group by 子句所定義的運算式中彙總資料最常出現的值 (模式值)。Mode() 函數可傳回數值和文字值。

[**mode**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/mode.htm)([**mode**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/mode.htm)**mode**mode(expression expression ))

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

#### Only

Only() 會傳回一個值 (如果彙總資料有且僅有一個可能結果)。如果由 group by 子句所定義的每個已分組結果內的記錄僅包含一個數值，則會傳回該值，否則會傳回 NULL。

[**only**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/only.htm)([**only**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/only.htm)**only**only(expression expression ))

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

#### Sum

Sum() 會計算由 group by 子句所定義的運算式中彙總的總值。

[**sum**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/sum.htm)([distinct]expression)

## 圖表運算式中的基本彙總函數

圖表彙總函數只能用於圖表運算式的欄位。一個彙總函數的引數運算式不能包含另一個彙總函數。

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

#### FirstSortedValue

FirstSortedValue() 會傳回在 value (對應於 sort\_weight 引數的排序結果) 中指定的運算式的值，並考慮到 rank (若已指定)。如果多個結果值對指定的 rank 共用同一個 sort\_weight，函數會傳回 NULL。

[**firstsortedvalue**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] value, sort\_weight [,rank])

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

#### Max

Max() 會找出彙總資料的最大值。透過指定 rank n，可找到第 n 個最大值。

[**max**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/max.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr [,rank])

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

#### Min

Min() 會找出彙總資料的最小數值。透過指定 rank n，可找到第 n 個最小值。

[**min**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/min.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr [,rank])

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

#### Mode

Mode() 會找出彙總資料中最常出現的值 (模式值)。Mode() 函數可處理文字值以及數值。

*[**mode**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/mode.htm)*({[SetExpression] [TOTAL [<fld {,fld}>]]} expr)

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

#### Only

Only() 會傳回一個值 (如果彙總資料有且僅有一個可能結果)。例如，搜尋唯一單位價格 =9 的產品時，如果多個產品單位價格為 9，則將傳回 NULL。

[**only**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/only.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

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

#### Sum

Sum() 會計算運算式或欄位指定的整個彙總資料的總值。

[**sum**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/sum.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr])