Delete Tables and Plots - Delete If Not Significant at the 0.001 Level (99.9%)

Deletes any of the selected tables and charts if they do not contain results that are significant at the 0.001 level.

This QScript deletes any of the selected tables and charts if they do not contain results that are significant at the 0.001 level.

Technical details

• Tables are deleted if they contain no cells with Corrected p values less than or equal to 0.001, excluding cells containing NET or SUM.
• For versions of Q before Q 4.8, the user selects tables and charts from a listbox.

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.

• 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

includeWeb("QScript Functions for Sort and Delete");