SET

Family: EVAL and its modifiers

Write it inside EVAL, or after the measure in VALUE_FOR, TOTAL or SHARE_OF_TOTAL.

Syntax

1
EVAL(measure, SET(dimension = value) [, SET(dimension = value) ...])

Arguments

Returns

The measure for that value of the dimension, on each row of the result.

Usage notes

• The rows that the SELECT returns do not change. Only this one value does.
• Several SETs apply in order, and each one sees the context the one before it set.
• Inside EVAL, the value can read CURRENT, such as CURRENT(orders.order_month) - 1. In VALUE_FOR, TOTAL and SHARE_OF_TOTAL, the value must be a constant.
• The measure’s own definition still applies.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.region AS "Region",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  MEASURE('web_units', EVAL(orders.sum__quantity, SET(orders.channel = 'web'))) AS "Web Units"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_NOT_NULL(orders.region)
8
GROUP BY
9
  orders.region
10
ORDER BY
11
  1

See also

• Change a measure’s context
• Pass through, evaluate or declare
• Other functions in EVAL and its modifiers: EVAL, CLEAR, REMOVE, SET_CUSTOM, CURRENT