QTD
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
This function is used to return a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension.
Syntax:
Qtd( [ Member_Expression ] )
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
MEMBER [Measures].[QTD Sales] AS
SUM(QTD([Date].[Calendar].CurrentMember), [Measures].[Internet Sales Amount])
MEMBER [Measures].[QTD Prev Quarter] AS
SUM(QTD([Date].[Calendar].CurrentMember.Lag(3)), [Measures].[Internet Sales Amount])
MEMBER [Measures].[QTD Growth %] AS
IIF([Measures].[QTD Prev Quarter] = 0, NULL,
([Measures].[QTD Sales] - [Measures].[QTD Prev Quarter]) / [Measures].[QTD Prev Quarter]),
FORMAT_STRING = 'Percent'