Modify Data - Move NET to the Top for All Questions

This QScript moves the NET (and SUM) to the top of the list of categories for all questions in the project. This means that the NET will appear as both the first row and first column in all tables.

Example

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 to Generate Outputs");

// Move the NET and SUM for all questions in all data files in the project
project.dataFiles.forEach(function(data_file) {
    var questions = data_file.questions.filter(function (q) { return q.isValid; });
    // if (Q.fileFormatVersion() > 8.81)
    //     questions = questions.filter(function (q) { return !q.isBanner; });
    questions.forEach(function (q) {
        moveNetToTopOrLeftOfDataReduction(q);
    });
});
 
conditionallyEmptyLog("QScript Finished.")
 
// Moves the code for the NET to the top or left
function moveNetToTopOrLeftOfDataReduction(question) {
    var data_reduction = question.dataReduction;
    var has_net_finder = !!data_reduction.netRows;
    var question_type = question.questionType;
    var net_rows = [];
    var net_columns = [];
    if (has_net_finder) {
        // Q10.5 and higher can get indices of NET rows/columns using
        // built-in functions.
        net_rows = data_reduction.netRows;
        net_columns = data_reduction.netColumns;
    } else {
        // Older versions need to look at the label for "NET" and "SUM"
        data_reduction.rowLabels.forEach(function (label, index) {
            if (label == "NET" || label == "SUM")
                net_rows.push(index);
        });
        if (data_reduction.columnLabels)
            data_reduction.columnLabels.forEach(function (label, index) {
            if (label == "NET" || label == "SUM")
                net_columns.push(index);
        });
    }
    net_rows.forEach(function (x) {
        if (x > 0) {
            if (question_type.indexOf ("Grid") > -1)
                data_reduction.moveAfter(data_reduction.transposed ? ~x :x, null);
            else
                data_reduction.moveAfter(x, null);
        }
    });
    net_columns.forEach(function (x) {
        // Columns indexed with negative integers, except when
        // Pick One - Multi questions show the NET in their columns
        if (Math.abs(x) > 0) {
            if (question_type == "Pick One - Multi")
                data_reduction.moveAfter(x, null);
            else if (question_type.indexOf ("Grid") > -1)
                data_reduction.moveAfter(data_reduction.transposed ? x :~x, null);
            else
                data_reduction.moveAfter(~x, null);
        }
    });
}

Prior to the 15th of December, 2015, this page was known as Modifying Rows and Columns - Move the NET to the Top for all Questions