Keys are a collection of one or more elements used to identify each record in the data. Q&R Query initially fills in this information based on the current key structure of the file. Key Selection defines the elements to be used as keys and the order in which they appear in the output. The order of the keys impacts the Q&R Charting presentation. On 2D charts, Q&R Charting allows the last two keys to be selected for either the X-axis or as the stack variable in 2D Stacked by Key charts.
The Key Selection task panel has the following fields:
Specifies the elements to use as a part of the key. The resulting data is sorted by default, based on the order that the elements are listed here.
Displays the element label.
Specifies how the element displays in the output.
Specifies whether the associated element is sorted in ascending or descending order. This selection reflects in the CSV output; however, Q&R Charting always orders the chart keys in ascending order.
Adds an element from a list of available elements.
Deletes the selected element from the key.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |