Hiding and Removing Categories (Missing Values)
|Related Online Training modules|
|Generally it is best to access online training from within Q by selecting Help > Online Training|
There are a number of different ways of removing categories from tables and each has a different consequence.
Removing categories and setting values as missing
Right-click on a category and select Remove simultaneously hides the category and recomputes any numbers on the table (e.g., if it is categorical data, the percentages are re-based). You can undo these changes by pressing undo or by right-clicking on the table and selecting Revert.
Where the categories are mutually exclusive (i.e., from a Pick One or Pick One - Multi question) you can right-click on rows or columns and select Values to open the Value Attributes, changing selections in the Missing Data column, and this is identical to using Remove.
Re-basing multiple response questions
When using Remove with a Pick Any question, sometimes you will see the NET drop below 100%, because some respondents will not have selected any of the responses. The most straightforward solution to this right-click on the percentage next to the NET, and select Create filter, ensure that Apply filter to the current table is selected and press OK.
You can also right-click on a category and select Hide to prevent it from being shown in the table. When you hide a category in this way no change is made to the other values on the table. You can undo hiding by pressing undo, or, right-clicking and selecting Revert (which returns the question to its original state).
You can also hide rows/columns where the first statistic is 0% or NaN in every cell of the row/column by pressing (located in the toolbar at the top of the screen).