Modify Headers - Automatically Remove NETs from Table

From Q
Jump to navigation Jump to search


This rule hides NET columns and NET rows on tables. Note that there are other tools available in Q for doing the same thing but in a more transparent way:

  • You can right-click on a category on a table and select Hide.
  • When exporting to Office there is an option called Ignore NET and SUM.
  • On Charts there is an option called Show NETs/SUMs.

Example

RemoveNETRule.png

How to apply this rule

For the first time in a project

  • Select the table(s)/chart(s) that you wish to apply the rule to.
  • Start typing the name of the Rule into the Search features and data box in the top right of the Q window.
  • Click on the Rule when it appears in the QScripts and Rules section of the search results.

OR

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

Additional applications of the rule

  • Select a table or chart that has the rule and any table(s)/chart(s) that you wish to apply the rule to.
  • Click on the Rules tab (bottom-left of the table/chart).
  • Select the rule that you wish to apply.
  • Click on the Apply drop-down and choose your desired option.
  • Check New items to have it automatically applied to new items that you create. Use Edit > Project Options > Save as Template to create a new project template that automatically uses this rule.

Removing the rule

  • Select the table(s)/chart(s) that you wish to remove the rule from.
  • Press the Rules tab (bottom-right corner).
  • Press Apply next to the rule you wish to remove and choose the appropriate option.

How to modify the rule

  • Click on the Rules tab (bottom-left of the table/chart).
  • Select the rule that you wish to modify.
  • Click Edit Rule and make the desired changes. Alternatively, you can use the JavaScript below to make your own rule (see Customizing Rules).

JavaScript

includeWeb("Table JavaScript Utility Functions");

form.setHeading("Automatically Remove NETs From Table");
form.setSummary("Automatically remove NETs from table");
let description = form.newLabel("Automatically removes the original table NET row and column");
description.lineBreakAfter = true;
form.setInputControls([description]);
 
// Delete any NET columns
table.netColumns.forEach(function (net_col, index) {
    deleteColumnComplete(net_col - index);
});

// Delete any NET rows
table.netRows.forEach(function (net_row, index) {
    deleteRowComplete(net_row - index);
});

See also