Using the QIQ Sort Properties Frame

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:

  1. 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.

  2. Select an option.

    • All Dashboards—All frames are available

    • Configured Dashboards—Only frames with applied sort configurations are available

    • Unconfigured Dashboards—Only frames without applied sort configurations are available

  3. From the drop-down list, directly under the options, select a frame.

    Available frames vary depending upon the selected option.

  4. Optional: To view the selected section, click View button.

To make all rows or x-axes available for sorting, select Use any existing Side Labels / X Categories.

*  To configure individual sort columns:

  1. In Manual Sort Configuration, from Embedded Sections, select a section.

  2. Optional: To view the selected section, click View button (next to Embedded Sections).

    Available Columns are displayed.

    The selected option, Row / X or Column / Depth, determines the Available Columns that are displayed.

  3. From Sort Options, select a sort function.

  4. Move selected columns between Available Columns and Sorted Columns by clicking Next button and Back button.

  5. Repeat steps 1–4 to configure all sort specifications.

  6. Optional: To return to a previously applied sort configuration, click Restore.

  7. Optional: To remove all applied sort configurations, click Clear.

  8. Click Apply to assign the specifications.

    Configured columns are displayed in the drop-down list when Sort Ascending button or Sort Descending button is clicked on the frame.

  9. Save the dashboard.

If Sort Ascending button and Sort Descending button 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.