Category:Rule Online Library
(Redirected from Rule Online Library)
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 79 pages are in this category, out of 79 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 - Hide Decimals without Rounding
- Modify Cell Content - Highlight Cells Above and Below NET Values
- 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 Columns Compared in Column Comparisons
- Modify Footers - Add Contents of SPSS Data File's Custom Attribute
- Modify Footers - Add Custom Description Conditional On Selected Question
- Modify Footers - Add Footnote to Cells with Small Sample Sizes
- Modify Footers - Add Footnote to Column Label with Small Sample Sizes
- Modify Footers - Add Smallest Sample Size
- Modify Headers - Abbreviate Month Labels
- Modify Headers - Add Column Letters to Column Labels
- Modify Headers - Add Sample Size to Column Labels
- Modify Headers - Change Column Labels
- Modify Headers - Change Row Labels
- Modify Headers - Hide NET Column
- Modify Headers - Hide NET Row
- Modify Headers - Hide NET Row and Column
- Modify Headers - Tidy Column Labels
- Modify Headers - Tidy Row Labels
- Modify Tables or Plots - Add Rank Column
- Modify Tables or Plots - Calculate Maximum Column Sample Size in 'Statistics - Below'
- Modify Tables or Plots - Ignore Missing Values in Column Sample Size in 'Statistics - Below'
- Modify Whole Table or Plot - Always Show Sample Size
- Modify Whole Table or Plot - Hide Columns with Small Sample Sizes
- Modify Whole Table or Plot - Hide Empty Columns
- Modify Whole Table or Plot - Hide Empty Rows
- 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 Output if has Small Sample Size
- Modify Whole Table or Plot - Hide Rows and Columns with Small Sample Sizes
- Modify Whole Table or Plot - Hide Rows with Small Sample Sizes
- Modify Whole Table or Plot - Move 'Statistics - Below' to Top
- Modify Whole Table or Plot - Replace Value with Rolling Average
- 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 - Unnest Nested Banner on Table
S
- Significance Testing in Tables - Color Comparisons for Specified Column
- Significance Testing in Tables - Color Significant Exception Test Results
- 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 - Move Column Comparisons to the Right of Values
- Significance Testing in Tables - Row Comparisons
- Significance Testing in Tables - Row Comparisons Using Column %
- 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 - Reverse Column Order
- Sort/Reorder Rows or Columns - Reverse Row Order
- Sort/Reorder Rows or Columns - Sort Columns
- Sort/Reorder Rows or Columns - Sort Rows
T
- Table Computations - Add Average Columns to Tables Containing Spans
- Table Computations - Add Average of Each Column
- Table Computations - Add Average of Each Row
- Table Computations - Add Average Rows to Tables Containing Spans
- Table Computations - Add Difference Between Pair of Columns
- Table Computations - Add Difference Between Pair of Rows
- Table Computations - Add Naïve Total for Each Column
- Table Computations - Add Naïve Total for Each Row
- Table Computations - Add Rows: Effective Column n
- Table Computations - Add Weighted Average of Each Column