CLEAR

Family: EVAL and its modifiers

Write it inside EVAL.

Syntax

1
EVAL(measure, CLEAR())

Arguments

CLEAR() takes no arguments.

Returns

The measure over every row that its definition allows, on each row of the result.

Usage notes

• CLEAR() also drops the query’s filters. To keep the filters and drop only some of the grouping, use REMOVE or TOTAL.
• The measure’s own definition still applies: the WHERE of its model and its required filters.
• It cannot be mixed with another modifier in the same EVAL.

Example

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

1
SELECT
2
  orders.channel AS "Channel",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  MEASURE('all_units', EVAL(orders.sum__quantity, CLEAR())) AS "All Units"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_EQUAL_TO(orders.region, 'AMER')
8
GROUP BY
9
  orders.channel
10
ORDER BY
11
  1

The query keeps only AMER, but All Units is the same on every row: the units of every region and every channel.

See also

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