Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3MemberSet

    Returns a reference to a set that can be used by other XLCubed formulae, for example the XL3RankLookup formula.

    Syntax

    XL3MemberSet( Connection, Hierarchy, Member, Function, [Parameter] )

    Parameters

    Parameter Description
    Connection Connection number to use
    Hierarchy The hierarchy of the following member
    Member The member to define the set relative to. Can also be a level
    Function The set function to use
    Parameter For set functions that require one, the parameter to use.

    Available Set Functions

    Set Function Returns Parameter Required
    Member A reference to a set containing only the specified member.
    Children A reference to the children of the specified member.
    FirstChild A reference to a set containing the first child of the specified member.
    LastChild A reference to a set containing the last child of the specified member.
    Descendants A reference to all the descendants of the specified member.
    LowestDescendants A reference to the lowest level descendants of the specified member.
    DescendantsAt A reference to the members of the descendants of the given member. Parameter should be either a number specifying the distance, or a level unique name to return the descendants for. Yes
    Next A reference to the specified member and the next N members, specified by Parameter. Yes
    Prev A reference to the specified member and the previous N members, specified by Parameter. Yes
    Siblings A reference to the members at the same level as the specified member.
    Parent A reference to a set containing the parent of the specified member.
    Ancestors A reference to all the ancestors of the specified member.
    FirstSibling A reference to a set containing the first sibling of the specified member.
    LastSibling A reference to a set containing the last sibling of the specified member.
    LevelMembers A reference to the members of a level. The Member parameter should be a level unique name instead of a member unique name.

    Examples

    For examples see XL3DataSeriesLookup or XL3RankLookup.

    See Also