When the Sort feature is first merged into an Interactive Reporting document, no sort specifications are active, specifications must be configured with QIQ Sort Properties. The Sort feature provides default sorting and configured sorting options. These options are set in QIQ Sort Properties. Default sorting is recommended based on simplicity and general applicability. With default sorting the developer need only specify whether sorting is available on a frame or not. For example, you can select to sort charts and pivots by columns that are present in the charts or pivots on that frame.
To configure sort specifications:
In Interactive Reporting Studio, navigate to QIQ Sort Properties.
To access the configuration frame, use Sections or the Configuration drop-down list found in Dashboard Studio.
Select an option.
From the drop-down list, directly under the options, select a frame.
Optional: To view the selected section, click .
To make all rows or x-axes available for sorting, select Use any existing Side Labels / X Categories.
To configure individual sort columns:
In Manual Sort Configuration, from Embedded Sections, select a section.
Optional: To view the selected section, click (next to Embedded Sections).
Available Columns are displayed.
The selected option, Row / X or Column / Depth, determines the Available Columns that are displayed.
From Sort Options, select a sort function.
Move selected columns between Available Columns and Sorted Columns by clicking and
.
Repeat steps 1–4 to configure all sort specifications.
Optional: To return to a previously applied sort configuration, click Restore.
Optional: To remove all applied sort configurations, click Clear.
Click Apply to assign the specifications.
Configured columns are displayed in the drop-down list when or
is clicked on the frame.
Save the dashboard.
If and
are added to all frames, they are only visible in frames with applied sort specifications.
Embedded sections must be associated in the Associate step of Dashboard Studio to enable them to be manipulated by the Sort feature. See Step 4.
After sort is applied, references to objects are stored as a Quick Sort property in the Interactive Reporting document. If these referenced objects (charts, pivots, tables, and columns) are removed or renamed, the configuration is obsolete, as these objects can no longer be found. The Sort feature verifies the configuration as it is loaded, and ignores obsolete elements. Loading takes place when QIQ Sort Properties is first activated, and when Apply is clicked.
A change to a configured section; for example, section names changed or removed, implies QIQ Sort Properties must be activated. In addition, Restore and Apply must be clicked, so the specification can be reloaded, corrected, and made permanent.