UNIQUE

The UNIQUE function returns a series containing all "unique" members of a series.

UNIQUE can only be used in a map rule, not in a component rule.

Syntax:
UNIQUE ( series-object-expression )
Meaning:
UNIQUE ( series_to_evaluate )
Returns:
A series object

UNIQUE evaluates to a series containing all unique members of series_to_evaluate and evaluates to "none" if series_to_evaluate evaluates to "none".

Examples

  • UNIQUE ( PartNumber:Inventory:File )

    Returns the unique PartNumbers in Inventory:File

  • COUNT ( UNIQUE ( Customer:Order:File ) )

    Returns the number of unique Customers in Order:File

Related functions

  • SORTDOWN
  • SORTUP

Feedback