GetNotSelectedCount
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.
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 |