CREATESLICETUPLESEGMENTS

This function creates multiple segments. It is an alternative to creating multiple individual segments with CREATESLICELISTSEGMENT.

Syntax

=CREATESLICETUPLESEGMENTS(hierarchies,Array_of_array_elements)

Example

This example is based on the Samples application.

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 #(Segment).