# GetSelectedCount

GetSelectedCount() finds the number of selected (green) values in a field.

Syntax:

GetSelectedCount (field\_name [, include\_excluded])

Return data type: integer

Arguments:

* field\_name: The field containing the range of data to be measured.
* include\_excluded: If set to True(), the count will include selected values, which are currently excluded by selections in other fields. If False or omitted, these values will not be included.
* state\_name: The name of an alternate state. If specified, the counted value for the field in the alternate state is returned. If no alternate state is provided, the default state is used.

The following table lists other functions that are related to this function.

Related functions

| Function | Interaction |
| --- | --- |
| [GetStateCounts](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getstatecounts.htm) | Using GetStateCounts(), you can combine the calculation of the following counts using a single function call:<br><br><ul> <li> <p>Count of selected included values.</p> </li> <li> <p>Count of possible values.</p> </li> <li> <p>Count of deselected values (only available if the field is in and-mode).</p> </li> <li> <p>Count of alternative values.</p> </li> <li> <p>Count of excluded values, not including alternative and selected excluded values.</p> </li> <li> <p>Count of selected excluded values.</p> </li> </ul> |
| [GetPossibleCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getpossiblecount.htm) | Returns the count of possible values. |
| [GetNotSelectedCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/GetNotSelectedCount.htm) | Returns the count of deselected values (only available if the field is in and-mode). |
| [GetAlternativeCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getalternativecount.htm) | Returns the count of alternative values. |
| [GetSelectedCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getselectedcount.htm#) | Returns the count of excluded values, not including alternative and selected excluded values. |

## Color of selection states in List Boxes

All information on this page refers to the color of selection states in a List Box with specific settings:

* The QlikView document configured to a Color Scheme of Classic Extended. See: [Selection Appearance](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Document_Properties_General.htm#SelectionAppearance)

* List Box configured with Show Alternatives turned on. See: [Show Alternatives](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/List_Box.htm#ShowAlternatives)

The following table outlines the color scheme for each selection state in a List Box with this configuration.

Color scheme for List box with given configuration

| State | Cell color | Text color |
| --- | --- | --- |
| Alternative | White | Gray |
| Deselected | Red | Black |
| Excluded | Gray | White |
| Possible | White | Black |
| Selected | Green | Black |
| Selected excluded | Gray | Green |

## Examples

The following example uses three fields loaded to different list boxes, one for First name name, one for Initials and one for Has cellphone.

Example 1: John selected in First name

`GetSelectedCount  ([First name])`

returns 1 as one value is selected in First name.

Example 2: John selected in First name

`GetSelectedCount  ([Initials])`

returns 0 as no values are selected in Initials.

Example 3: no selections in First name, all values selected in Initials, and Yes selected in Has cellphone

`GetSelectedCount  ([Initials], True())`

returns 6. Although selections with InitialsMC and PD have Has cellphone set to No, the result is still 6, because the argument include\_excluded is set to True().

Data used in example:

`Names:` `LOAD * inline [` `"First name"|"Last name"|Initials|"Has cellphone"` `John|Anderson|JA|Yes` `Sue|Brown|SB|Yes` `Mark|Carr|MC |No` `Peter|Devonshire|PD|No` `Jane|Elliot|JE|Yes` `Peter|Franc|PF|Yes ] (delimiter is '|');`