Calculation - Maximum - Maximum Each Column

From Q
Jump to navigation Jump to search

Compute the maximum for each column of a single input This tool is used to compute the maximum value for each column in a table.

Example

Consider the following table which shows the average number of times the respondents order meals at different fast food chains in a given month:

We can use Maximum Each Column to compute the largest average for each column across all occasions:

Options

Input The table to be used in the calculation.

Calculate for inputs with incomplete data If this option is checked, than any missing values the input will be ignored in the calculation. If unchecked, then missing values are not removed before calculation and will propagate as missing values in the output.

Rows to include This listbox shows all row labels in the input. The calculation will not performed for any rows whose labels are unselected here and they will not be shown in the output. By default the "SUM" and "NET" rows and columns are not shown in the output.

Columns to include As above, but for columns; any column labels unselected here will not be included in the output.

Technical Details

When Calculate for inputs with incomplete data is checked and the input to the calculation consists entirely of missing values, then the returned output value is set to missing data. Prior to 5th October, 2021 the returned output value was different in this situation. For example, consider the input into the calculation with the three values.

A B C
NaN NaN NaN

Then applying Maximum Each Column to this input returned the value of -Infinity for each element before 5th October, 2021. After this date, the Maximum Each Column function returns the output value of NaN for each element.

Maximum Each Column
A B C
before 5th October, 2021 -Infinity -Infinity -Infinity
after 5th October, 2021 NaN NaN NaN

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

  • Copy the JavaScript shown on this page.
  • 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.

JavaScript

includeWeb('QScript Functions for Calculations');
includeWeb('QScript Functions to Generate Outputs');

applySingleDimensionCalculationWithSelection('Maximum', 'Column');

See also