Sort/Reorder Rows or Columns - Sort Categories from Highest to Lowest (Does Not Update When Data Changes)

Example

Technical details

• Categories which look like 'Other/Specify', 'Don't Know', 'None of these', or 'All of these' style responses, as well as the NET and SUM rows, will be left at the bottom of the table.
• This QScript will not try to sort questions that look like scale questions, according to the rules of the function looksLikeScale.
• Tables are sorted in the descending order of the relevant statistic, as determined by their Question Type:
  • Pick One, Pick Any, and Pick Any - Compact questions are sorted according to the % shown in their SUMMARY table.
  • Number - Multi questions are sorted according to the Average shown in their SUMMARY table.
  • Ranking questions are sorted according to the Probability % shown in their SUMMARY table.
  • Pick One - Multi questions are sorted according to the Row % in the right-most column of their SUMMARY table that is not the NET column. If the question has had its rows and columns swapped then the question is sorted by according to the Column % shown in the bottom-most row of its SUMMARY that is not the NET row.
  • Pick Any - Grid questions are sorted according to the % shown in the first column of their SUMMARY table that is not the NET column.
  • Number - Grid questions are sorted according to the Average shown in the first column of their SUMMARY table that is not the SUM column.

Technical details

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 from Highest to Lowest (Does Not Update When Data Changes)