Between between

Syntax

between ( op, from, to )

ds2 := between(ds1, 5, 10)
ds2 := ds1 [ calc m1 := between(me2, 5, 10) ]

The operator returns TRUE if op is greater than or equal to from and lower than or equal to to. In other terms, it is a shortcut for the following:

op >= from and op <= to

The types of op, from and to must be compatible scalar types.

op

dataset {measure<scalar> _}
| component<scalar>
| scalar

from, to

component<scalar>
| scalar

result

dataset { measure<boolean> bool_var }
| component<boolean>
| boolean

The type of the operand (i.e., the measure of the dataset, the type of the component, the scalar type) must be the same as that of from and to.

The operator has the typical behaviour of the “Operators changing the data type” (see the section “Typical behaviours of the ML Operators”)

Given the operand dataset DS_1:

Input DS_1 (see structure)

Id_1	Id_2	Id_3	Id_4	Me_1
G	Total	Percentage	Total	6
R	Total	Percentage	Total	-2

DS_r:= between(DS_1, 5, 10);

results in (see structure):

DS_r
Id_1	Id_2	Id_3	Id_4	bool_var
G	Total	Percentage	Total	True
R	Total	Percentage	Total	False