Axes Property

Official Content
This documentation is valid for:

We can use this property when we have to act programmatically on the elements of the chart axes. It contains the name of the variable based on the QueryViewerAxes SDT.

Values

&Axes Name of the variable that will implement the changes’ inherent properties. This is the default value.

 

QueryViewerAxes SDT Structure

SDTQueryViewerAxes

  • QueryViewerExpandCollapse is Character(20)
  • QueryViewerAxisType is Character(20)

Example

For the following example, we will take the following query in the ClientsQuery object as a reference.

ClientsQuery Query

The information displayed can often be lengthy when the elements that comprise it are expanded (default setting). This may be easily avoided by collapsing all the elements starting from the first one, or from another element close to the first one. Later on, the user will expand those nodes as needed.

In the image below, the PivotTable is completely expanded.

PivotExpanded

The following code shows how to completely collapse all the elements.

Event Start
    &Axis = New()
    &Axis.Name = "ClientId"
    &Axis.ExpandCollapse.Type = QueryViewerExpandCollapse.CollapseAllValues
    &Axes.Add(&Axis)
EndEvent

Note that the element being collapsed –ClientId– is the first one in the query, and therefore it will be the first column in the query. The result would be as follows:

PivotCollapseAllValues

If we needed to collapse from the ClientActive element, for example, we would select it instead of ClientId, as shown below:

&Axis.Name = "ClientAdmissionDate”

... and the result would be as shown in the image below.

PivotCollapseFromDate

Scope

Output type: Table, PivotTable, Chart

 



Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.