There are a few pseudo-variables which have special functions in the expression language. The following specials are column-like, in that they have a different value for each row:
$index
or $0
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.
The deprecated alias "INDEX
" may also be used.
$index0
or $00
$random
0<=x<1
with a value which is fixed for a given row in this expression.
The quality of the random numbers may not be particularly good.
The deprecated alias "RANDOM
" may also be used.
The following specials are parameter-like, in that their value is not sensitive to the row:
$nrow
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.
$ncol
$nrow0
$nrow
if a non-default
current subset is selected.
$ncol0
$ncol
if some columns are
currently hidden.