# GetPossibleCount

GetPossibleCount() is used to find the number of possible (white) values in the identified field. If the identified field includes selections, then the selected (green) fields are also counted.

For fields with selections, GetPossibleCount() returns the number of selected (green) fields.

**Return data type:** integer

Syntax:

GetPossibleCount (field\_name)

Arguments:

* field\_name: The field containing the range of data to be measured.

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> |
| [GetSelectedCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getselectedcount.htm) | Returns the count of selected included 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. |
| [GetPossibleCount](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getpossiblecount.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 examples use two fields loaded to different list boxes, one for First name name and one for Initials.

Example 1: John selected in First name

`GetPossibleCount  ([Initials])`

returns 1 as there is 1 value in Initials associated with the selection, John, in First name.

Example 2: John selected in First name

`GetPossibleCount  ([First name])`

returns 1 as there is 1 selection, John, in First name.

Example 3: Peterselected in First name

`GetPossibleCount  ([Initials])`

returns 2 as Peter is associated with 2 values in Initials.

Example 4: no values selected in First name

`GetPossibleCount  ([First name])`

returns 5 as there are no selections and there are 5 unique values in First name.

Example 5: no values selected in First name

`GetPossibleCount  ([Initials])`

returns 6 as there are no selections and there are 6 unique values in Initials.

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 '|');`