Minimum/maximum statements

These statements get information about the largest or smallest value within a region level or dimension level.

The get-statements have the following form:

{get: <what>; <parameters>}

Functions

The value of specifies <what> function is requested. The following functions can be requested:

varcode

{get:maximum-value; varcode: bevtot; geolevel: municipality; option:region}

dim-item

{get:maximum-value; varcode: kb_cbs_bev_lft_gsl; geoselect:base; option:dimitem; dimlevel: dnc_alg_lft1}

Retrieves the largest age class for the selected base region.

geolevel

{get:maximum-value; varcode: bevtot; geolevel: municipality; option:regionvalue}

Retrieves the value of the municipality with the largest population.

geoitem

{get:maximum-value; varcode: kb_cbs_bev_lft_gsl; geolevel:municipality; geoitem:1680; option:dimitem; dimlevel: dnc_alg_lft1}

Retrieves the largest age class for the specified region.

geoselect: base

{get:minimum-value; varcode: bevtot; geoselect:base; option:region}

Retrieves the name of the municipality with the smallest population of the selected base region.

geoselect: compare

{get:minimum-value; varcode: bevtot; geoselect:compare; option:regionvalue}

Retrieves the value of the municipality with the smallest population of the selected compare region.

dimselect: base

{get:maximum-value; varcode: kb_cbs_bev_lft_gsl; geoselect:base; option:dimitem; dimlevel: dnc_alg_lft1}

Retrieves the largest age class for the selected base region.

dimselect: compare

{get:maximum-value; varcode: kb_cbs_bev_lft_gsl; geoselect:compare; option:dimitem; dimlevel: dnc_alg_lft1}

Retrieves the largest age class for the selected compare region.

offset: number > 0

{get:maximum-value; varcode: bevtot; geolevel: municipality; option:regionvalue; offset: 1}

Offset is an optional parameter; If not specified, the min/max value is used.

option

{get:maximum-value; varcode: bevtot; geolevel: gemeente16; parentselect: compare; option:region}

Specifies what value is requested. The following values can be requested: region, regionvalue, dimitem, dimvalue.

parentlevel

{get:maximum-value; varcode: bevtot; geolevel: municipality; option:regionvalue; parentlevel: provincie; parentitem: 1}

Retrieves the value of a specified region of the parentlevel. parentlevel only works in conjunction with parentitem.

parentitem

{get:maximum-value; varcode: bevtot; geolevel: municipality; option:regionvalue; parentlevel: provincie; parentitem: 1}

Retrieves the value of a specified region of the parentlevel. parentitem only works in conjunction with parentlevel.

parentselect

{get:maximum-value; varcode: bevtot; geolevel: gemeente16; parentselect: base; option:region}

Retrieves the largest value of the childitems of the specified parentregion.

period

{get:maximum-value; varcode: bevtot; geolevel: municipality; period:2016; option:region}

Period is an optional parameter; if not specified, the mostrecentperiod is used.

periodoffset: number < 0

{get:maximum-value; varcode: bevtot; geolevel: municipality; periodoffset:-1; option:region}

Periodoffset is an optional parameter; if not specified, the mostrecentperiod is used.

roundoff:

{get:maximum-value; varcode: bevtot; geolevel: municipality; roundoff:1; option:region}

Roundoff is an optional parameter; if not specified, the roundoff in the Indicators table in Studio is used.

Min/Max Variable

It is also possible to supply a list of variables and retrieve name or value of the variable with the highest or lowest value.

This can be done as follows:

{get:maximum-value; varcodes: bevtot,bevtot2,bevtot3; option:variable}

This retrieve the name of the variable with the highest value based on the current user selection.

{get:minimum-value; varcodes: bevtot,bevtot2,bevtot3; option:variablevalue}

This retrieve the value of the variable with the lowest value based on the current user selection.

Parameters

The value of parameter specifies what parameter is used. The parameters must be separated by ";". The following parameters can be used: 

• varcode
• varcodes*
• dim-item
• geolevel
• geoitem
• geoselect: base or compare
• dimselect: base or compare
• offset: number > 0
• option
• parentlevel
• parentitem
• parentselect
• period
• periodoffset: number < 0
• roundoff: if not specified, the retrieved data will use the roundoff specified in the Indicators table in Studio

(*) varcodes only works with the option variable and variablevalue.

The offset parameter specifies which offset of the minimum/maximum should be used.

If specified, it will takes the n-th minimum/maximum.

The option parameter specifies what value is requested.

The following values can be requested:

• region: looks for the region with the minimum/maximum value.
• regionvalue: looks for minimum/maximum value within the region level.
• dimitem: looks for the dimension item with the minimum/maximum value.
• dimvalue: looks for minimum/maximum value within the dimension level.
• variable*: looks for the name of the variable with the minimum/maximum value.
• variablevalue*: looks for the value of the variable with the minimum/maximum value.

(*) For these options, a list of variables must be supplied.