Articles in this section

See more

Sort/Reorder Rows or Columns - Sort Category Labels by Largest Category Value

  • Updated
Follow
The QScript Sort/Reorder Rows or Columns - Sort Category Labels by Largest Category Value
sorts the categories in the selected Pick One and Pick One - Multi questions according to the underlying value for each category (as shown in the Value Attributes). The categories are sorted so that the category with the highest value placed at the top (or left) of the table, and the category with the lowest value at the bottom (or right) of the table. Categories which have been created by combining merging several categories together will not be sorted.

Example

A question "Brand Satisfaction" with the ratings scale from 1 (Very unsatisfied) to 5 (Very satisfied) in the columns of the table will change into 5 (Very satisfied) to 1 (Very unsatisfied).

How to apply this QScript

  • Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
  • Click on the QScript when it appears in the QScripts and Rules section of the search results.

OR

  • Select Automate > Browse Online Library.
  • Select this QScript from the list.

Customizing the QScript

This QScript is written in JavaScript and can be customized by copying and modifying the JavaScript.

Customizing QScripts in Q4.11 and more recent versions

  • Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
  • Hover your mouse over the QScript when it appears in the QScripts and Rules section of the search results.
  • Press Edit a Copy (bottom-left corner of the preview).
  • Modify the JavaScript (see QScripts for more detail on this).
  • Either:
    • Run the QScript, by pressing the blue triangle button.
    • Save the QScript and run it at a later time, using Automate > Run QScript (Macro) from File.

Customizing QScripts in older versions

  • Contact support@q-researchsoftware.com to obtain a copy of the JavaScript code.
  • Create a new text file, giving it a file extension of .QScript. See here for more information about how to do this.
  • Modify the JavaScript (see QScripts for more detail on this).
  • Run the file using Automate > Run QScript (Macro) from File.

Prior to the 15th of December, 2015, this page was known as Sort - Sort Category Labels by Largest Category Value

See also

Related articles