This chart function returns the number of not-selected (red cell with black text) values in the field named fieldname. The field must be in and-mode for this function to be relevant.
Syntax:
GetNotSelectedCount ( field_name [, include_excluded])
(Inherited)GetNotSelectedCount ( FieldName [, IncludeExcluded])
Arguments:
- field_name: The field containing the range of data to be measured.
- include_excluded: If IncludeExcluded is 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.
The following table lists other functions that are related to this function.
| Function | Interaction |
|---|---|
| GetStateCounts |
Using GetStateCounts(), you can combine the calculation of the following counts using a single function call:
|
| GetSelectedCount | Returns the count of selected included values. |
| GetPossibleCount | Returns the count of possible values. |
| GetAlternativeCount | Returns the count of alternative values. |
| GetNotSelectedCount | Returns the count of excluded values, not including alternative and selected excluded values. |
Example:
GetNotSelectedCount ( Year )
GetNotSelectedCount (Year,True())
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
-
List Box configured with Show Alternatives turned on. See: Show Alternatives
The following table outlines the color scheme for each selection state in a List Box with this 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 |
