How to Create Top K Category Variable(s) (Top K Boxes)

This article describes how to you can create new variables that show the proportion of respondents who selected the top K options in Nominal, Nominal - Multi, Ordinal or Ordinal - Multi variable sets, in other words, Displayr computes what is commonly referred to as 'Top K Box' percentages. Categories that look like Don't know options will not be included in the bottom boxes, and when such categories are identified the script will give you the option to remove them.

The table on the left shows a Summary table of a Nominal - Multi question. The table on the right shows a Summary of the Binary - Multi. 

Requirements

• A data set loaded into Displayr that contains Nominal, Nominal - Multi, Ordinal or Ordinal - Multi variable sets.

Method

1. Displayr identifies the bottom options by looking at the numeric Value for each category that is not selected as Missing Data in the Value Attributes, of the variable set, and choosing the lowest. 
2. OPTIONAL: To find out what the numeric values are, select the variable set in the Data Set tree.
3. OPTIONAL: Then in the object inspector on the right of your screen, under Properties > DATA VALUES click on Select categories. 
   
4. To create a 'Top K Box' variable select the variable set in the Data Sets tree.
5. Either hover over any variable in your Data Sets tree > Plus (+) > Insert Variable(s) > Ready-Made New Variable(s) > Top K Category Variable(s) (Top K Boxes) or else from the toolbar menu, select Anything > Data > Variables > New > Ready-Made New Variable(s) > Top K Category Variable(s) (Top K Boxes).
   
6. Displayr will ask you how many categories you wish to combine, for example, to combine the bottom two categories type '2' and press OK.
7. Displayr will then create new variables for the top 2 categories of each selected variable set. The Value Attributes may look something similar to below:
   
   

Notes

• Displayr identifies the bottom options by looking at the numeric Value for each category that is not selected as Missing Data in the Value Attributes, of the variable set, and choosing the lowest. 
• To find out what the numeric values are, select the variable set in the Data Set tree, and then in the object inspector on the right of your screen, under Properties > DATA VALUES click on Select categories. 
  

Next

How to Create Top Two Category Variable(s) (Top 2 Boxes)
How to Create Top Three Category Variable(s) (Top 3 Boxes)

Manipulating Data