# 範圍函數

範圍函數是一種使用值陣列，產生單一值作為結果的函數。所有範圍函數皆可用於載入指令碼和圖表運算式。

例如，在圖表中，範圍函數可從記錄間陣列計算出單一值。在載入指令碼中，範圍函數可從內部表格中的值陣列計算出單一值。

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

資訊備註範圍函數會取代下列一般數值函數：numsum、numavg、numcount、nummin 和 nummax。這些函數仍可使用，但不建議使用。

## 基本範圍函數

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMax

RangeMax() 會傳回在運算式或欄位內所出現的最大數值。

[**rangemax**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangemax.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMaxString

RangeMaxString() 會傳回在運算式或欄位內依文字排序順序出現的最後一個值。

[**rangemaxstring**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangemaxstring.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMin

RangeMin() 會傳回在運算式或欄位內所出現的最小數值。

[**rangemin**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangemin.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMinString

RangeMinString() 會傳回在運算式或欄位內依文字排序順序出現的第一個值。

[**rangeminstring**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangeminstring.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMode

RangeMode() 會找出運算式或欄位中最常出現的值 (模式值)。

[**rangemode**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangemode.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeOnly

RangeOnly() 是 dual 函數，如果運算式評估為一個唯一值，則該函數會傳回一個值。如果情況不是如此，則會傳回 NULL。

[**rangeonly**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangeonly.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeSum

RangeSum() 會傳回一個範圍值的加總。與 + 運算子不同，會將所有非數值視為 0。

[**rangesum**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangesum.htm)(first\_expr[, Expression])

## 計數器範圍函數

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeCount

RangeCount() 會傳回運算式或欄位中的值（文字值和數值）的數量。

[**rangecount**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangecount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMissingCount

RangeMissingCount() 會傳回運算式或欄位中的非數值 (包括 NULL) 的數量。

[**rangemissingcount**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangemissingcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNullCount

RangeNullCount() 會找出運算式或欄位中 NULL 值的數量。

[**rangenullcount**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangenullcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNumericCount

RangeNumericCount() 會找出運算式或欄位中數值的數量。

[**rangenumericcount**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangenumericcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeTextCount

RangeTextCount() 會傳回運算式或欄位中文字值的數量。

[**rangetextcount**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangetextcount.htm)(first\_expr[, Expression])

## 統計範圍函數

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeAvg

RangeAvg() 會傳回範圍的平均值。函數的輸入可以是一個範圍的值，也可以是運算式。

[**rangeavg**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangeavg.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeCorrel

RangeCorrel() 會傳回兩組資料的相關係數。相關係數是資料集之間關係的量值。

[**rangecorrel**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangecorrel.htm)(x\_values , y\_values[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeFractile

RangeFractile() 傳回對應於一定範圍數字中第 n 個 fractile (分位數) 的值。

[**rangefractile**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangefractile.htm)(fractile, first\_expr[ ,Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeKurtosis

RangeKurtosis() 會傳回對應於一個範圍數字的峰度值。

[**rangekurtosis**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangekurtosis.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeSkew

RangeSkew() 會傳回對應於一個範圍數字的偏態的值。

[**rangeskew**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangeskew.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeStdev

RangeStdev() 會找出一個範圍數字的標準差。

[**rangestdev**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/rangestdev.htm)(expr1[, Expression])

## 財務範圍函數

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeIRR

RangeIRR() 會針對輸入值所代表的一組現金流量，傳回內部報酬率。

[**RangeIRR**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/RangeFunctions/RangeIRR.htm)(value[, value][, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNPV

RangeNPV() 會根據折扣率以及一系列未來支出 (負值) 和收入 (正值)，傳回投資的彙總淨現值。結果具有money的預設數字格式。

[**RangeNPV**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/RangeFunctions/RangeNPV.htm)(discount\_rate, value[, value][, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeXIRR

RangeXIRR() 會針對不一定為週期性的現金流量表，傳回內部報酬率。若要計算一系列週期性現金流量的內部報酬率，請使用 RangeIRR 函數。

[**RangeXIRR**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/RangeFunctions/RangeXIRR.htm)(values, dates[, Expression])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeXNPV

RangeXNPV() 會針對不一定為週期性的現金流量表，傳回淨現值。結果的預設數字格式為貨幣。若要計算一系列週期性現金流量的淨現值，請使用 RangeNPV 函數。

[**RangeXNPV**](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/RangeFunctions/RangeXNPV.htm)(discount\_rate, values, dates[, Expression])

## 瞭解更多資訊

* [記錄間函數](https://help.qlik.com/zh-TW/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/inter-record-functions-charts.htm)