# 范围函数

范围函数是采用值数组并产生单个值作为结果的函数。所有范围函数都可用于数据加载脚本和图表表达式。

例如，在可视化中，范围函数可用于计算内部记录函数的单个值。在数据加载脚本中，范围函数可用于计算内部表中值阵列的单个值。

使用每个函数的下拉列表可查看每个函数的简短描述和语法。单击语法描述中的函数名称可了解更多信息。

信息注释范围函数可替代以下一般数字函数：numsum、numavg、numcount、nummin 和 nummax（现在应被视为已过时）。

## 基本范围函数

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMax

RangeMax() 用于返回在表达式或字段内找到的最高数值。

[**rangemax**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangemax.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMaxString

RangeMaxString() 用于以文本排序顺序返回在表达式或字段中找到的最后一个值。

[**rangemaxstring**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangemaxstring.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMin

RangeMin() 用于返回在表达式或字段内找到的最低数值。

[**rangemin**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangemin.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMinString

RangeMinString() 用于以文本排序顺序返回在表达式或字段中找到的第一个值。

[**rangeminstring**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeminstring.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMode

RangeMode() 用于查找表达式或字段中最常出现的值（即模式值）。

[**rangemode**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangemode.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeOnly

RangeOnly() 是一个对偶函数，用于返回一个值（如果表达式计算为一个独特的值）。如果不是一个独特的值，则返回 NULL 值。

[**rangeonly**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeonly.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeSum

RangeSum() 返回一系列值的总和。所有非数字值均被视为0。

[**rangesum**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangesum.htm)(first\_expr[, Expression])

## 计数器范围函数

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeCount

RangeCount() 用于返回表达式或字段中文本值和数字值的数量。

[**rangecount**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangecount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeMissingCount

RangeMissingCount() 用于返回表达式或字段中非数字值（包括 NULL）的数量。

[**rangemissingcount**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangemissingcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNullCount

RangeNullCount() 用于查找表达式或字段中 NULL 值的数量。

[**rangenullcount**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangenullcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNumericCount

RangeNumericCount() 用于查找表达式或字段中数字值的数量。

[**rangenumericcount**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangenumericcount.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeTextCount

RangeTextCount() 用于返回表达式或字段中文本值的数量。

[**rangetextcount**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangetextcount.htm)(first\_expr[, Expression])

## 统计范围函数

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeAvg

RangeAvg() 用于返回范围的平均值。可以将一系列值或表达式导入该函数。

[**rangeavg**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeavg.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeCorrel

RangeCorrel() 用于返回两组数据的相关系数。相关系数是数据集之间关系的度量。

[**rangecorrel**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangecorrel.htm)(x\_values , y\_values[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeFractile

RangeFractile() 用于返回与数值系列的第 n 个fractile（位数）对应的值。

[**rangefractile**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangefractile.htm)(fractile, first\_expr[ ,Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeKurtosis

RangeKurtosis() 用于返回与数值范围的峰度对应的值。

[**rangekurtosis**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangekurtosis.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeSkew

RangeSkew() 用于返回与数值范围的偏度对应的值。

[**rangeskew**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeskew.htm)(first\_expr[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeStdev

RangeStdev() 用于查找数字系列的标准偏差。

[**rangestdev**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangestdev.htm)(expr1[, Expression])

## 财务范围函数

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeIRR

RangeIRR() 用于返回按输入值表示的一系列现金流的内部回报率。

[**RangeIRR**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/RangeFunctions/RangeIRR.htm)(value[, value][, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeNPV

RangeNPV() 用于返回基于折扣率和一系列未来定期付款（负值）和收入（正值）的投资的净现值。结果拥有一个 money 的默认数字格式。

[**RangeNPV**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/RangeFunctions/RangeNPV.htm)(discount\_rate, value[, value][, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeXIRR

RangeXIRR() 用于返回现金流时间表的内部回报率（每年）。要计算一系列周期性现金流的内部回报率，请使用 RangeIRR 函数。

[**RangeXIRR**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/RangeFunctions/RangeXIRR.htm)(values, dates[, Expression])

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/RangeFunctionsInCharts.htm)

#### RangeXNPV

RangeXNPV() 用于返回通过 pmt 和 date 指定表达式中成对数值表示的现金流时间表（不一定是周期性）的净现值。所有付款按 365 天一年年折扣。

[**RangeXNPV**](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/RangeFunctions/RangeXNPV.htm)(discount\_rate, values, dates[, Expression])

## 了解详情

* [内部记录函数](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/inter-record-functions-charts.htm)