Calculate eastings and northings of centroid within polygon layer
xmin(centroid($geometry))
ymin(centroid($geometry))
Calculate area and perimeter of a polygon layer
$area
$perimeter
Calculate eastings and northings of a point layer
$x
$y
Calculate the length of a line layer
$length
Capitalise column values
upper(Field)
eg upper(Town)
Edinburgh becomes EDINBURGH
Camel case column values
title(Field)
EDINBURGH becomes Edinburgh
DUDDINGSTON LOCH becomes Duddingston Loch
Lower case column values
lower(Field)
Replacethis withthat in string
replace(string, replacethis, withthat)
Concatenate string a and string b
Concatenate a || b
Division and next line Multiplication
a/b
a*b
area/10,000 – divides area field by 10,000 (eg going from m2 to Hectares
Remove decimals from a field
toint(area)
eg 7954.235 becomes 7954 and 456525.325 becomes 456525
Index a set of polygons
$rownumber