The Rule Online Library contains a set of Rules that can be applied to tables and charts directly from Q. These have been written to accomplish some common table and chart manipulations that users wish to apply in Q. This includes changing labels, changing the colors of cells, adding new rows and columns, and more.
Applying Rules To Tables and Charts
This feature is available in Q version Q 4.8 and higher. To apply one of these rules to a table or chart:
- Select the relevant Tables or Charts in your Report.
- Select Automate > Online Library.
- Select the rule from the list. Rules appear with the icon:
.
- Make any selections (e.g. colors, statistics, etc) that are appropriate to the rule.
- Click OK.
Any options that are available for a rule (for example, selecting colors and statistics) can be changed by selecting the Rules tab tab below your table, selecting the rule from the list, and then clicking Edit Rule.
Pages in category 'Rule Online Library'
The following 71 pages are in this category, out of 71 total.
M
- Modify Cell Content - Add Symbols to Significant Cells
- Modify Cell Content - Add Text to Cells with Large Numbers
- Modify Cell Content - Blank Cells with Small Sample Sizes
- Modify Cell Content - Blank Cells with Small Values
- Modify Cell Content - Change Color of Cells with Small Sample Sizes
- Modify Cell Content - Change Missing Data (NaN) Symbol
- Modify Cell Content - Color Selected Rows or Columns
- Modify Cell Content - Highlight Cells Above and Below NET
- Modify Cell Content - Remove Decimals Without Rounding
- Modify Cell Content - Replace Small Values With Text
- Modify Cell Content - Round Data
- Modify Cell Content - Shade Alternate Rows or Columns
- Modify Cell Content - Shade Alternate Spans
- Modify Cell Content - Shade NET Rows and Columns
- Modify Footers - Add Column Base Sizes
- Modify Footers - Add Column Header Footnote Indicating Small Sample Sizes
- Modify Footers - Add Footer Showing Smallest Sample Size on Table
- Modify Footers - Add Footnote for Cells with Small Sample Sizes
- Modify Footers - Description of Selected Data (e.g., Question Name, Skips, Filtering)
- Modify Footers - Display SPSS Custom Attribute
- Modify Footers - Display Which Columns Are Being Compared
- Modify Headers - Abbreviate Month Labels
- Modify Headers - Add Column Names to Column Labels
- Modify Headers - Add Sample Size to Column Labels
- Modify Headers - Automatically Remove NET Column
- Modify Headers - Automatically Remove NET Row
- Modify Headers - Automatically Remove NETs from Table
- Modify Headers - Automatically Rename Column Labels
- Modify Headers - Automatically Rename Row Labels
- Modify Tables or Plots - Ignore Missing Values in Column Sample Size in Statistics Below
- Modify Tables or Plots - Show Average Rank
- Modify Tables or Plots - Show Maximum Column Sample Size in Statistics Below
- Modify Whole Table or Plot - Always Show Sample Size
- Modify Whole Table or Plot - Avoid Showing Outputs with Small Sample Sizes
- Modify Whole Table or Plot - Hide Empty Rows and Columns
- Modify Whole Table or Plot - Hide Non-significant Rows and Columns
- Modify Whole Table or Plot - Hide Rows and Columns with Small Sample Sizes
- Modify Whole Table or Plot - Replace with Rolling Averages
- Modify Whole Table or Plot - Show a Range of Rows
- Modify Whole Table or Plot - Show Each Statistic in Separate Column
- Modify Whole Table or Plot - Show Only Top K and Specified Rows
- Modify Whole Table or Plot - Show Only Top K Rows (e.g., Top 5 Rows)
- Modify Whole Table or Plot - Show Statistics Above
- Modify Whole Table or Plot - Unnest Nested Banner on Table
S
- Significance Testing in Tables - Color Comparisons with Specific Column
- Significance Testing in Tables - Color Significant Cells
- Significance Testing in Tables - Column Comparisons on Grids with Lots of Missing Data
- Significance Testing in Tables - Independent Samples Column Means and Proportions Tests
- Significance Testing in Tables - Row Comparisons
- Significance Testing in Tables - Row Comparisons Using Column %
- Significance Testing in Tables - Show Column Comparisons to the Right of Values
- Sort/Reorder Rows or Columns - Change the Order of Statistics
- Sort/Reorder Rows or Columns - Make One Column Appear After Another
- Sort/Reorder Rows or Columns - Make One Row Appear After Another
- Sort/Reorder Rows or Columns - Move NET Row to the Top
- Sort/Reorder Rows or Columns - Sort Rows (Automatically Updates When Data Changes)
T
- Table Computations - Add Average Columns to Tables Containing Spans
- Table Computations - Add Average Rows to Tables Containing Spans
- Table Computations - Add Naive Total For Each Column
- Table Computations - Add Naive Total For Each Row
- Table Computations - Add Rows to Display Effective Column n
- Table Computations - Add Rows to Display Effective Column Sample Size
- Table Computations - Average of Each Column
- Table Computations - Average of Each Row
- Table Computations - Difference Between Pair of Columns
- Table Computations - Difference Between Pair of Rows
- Table Computations - Weighted Average of Each Column