CREATESLICETUPLESEGMENTS

Creates multiple segments. It is an alternative to creating multiple individual segments with CREATESLICELISTSEGMENT.

See CREATESLICELISTSEGMENT.

Syntax

=CREATESLICETUPLESEGMENTS("Array of hierarchies","Array of array of elements")

Example

This example is based on the Best Practices Templates sample database.

Cells A5 and A6 each contain a hierarchy. For example, [period] and [pos].

Cell A7 contains =A5:A6. The cell displays the array of the hierarchies in A5 and A6. For example, #("[period]","[pos]").

Cells H5 and H6 each contain an array of elements. That is, the unique names of two or more elements, separated by commas.

Cell H7 contains =H5:H6. The cell displays an array which contains the arrays of elements in H5 and H6.

The function =CREATESLICETUPLESEGMENTS(A7,H7) returns #(Segments).

Related topics