Color of Forced excluded is - red. This is associated with And mode selection. Check the attached sample. Press Ctrl, click and hold for sometime in the list box that is enabled with and mode, it will turn into red - and that is forced excluded.
SelectExcluded_tres.qvw 147.8 K
A field can be enabled with and-mode only if it satisfies few conditions. from help:
A field cannot always be set to logical And mode. The reason for this is that the and alternative is logically
meaningful only if the concerned field is linked to only one other field.
The And mode option is only allowed under very strict conditions, imposed by the theory behind the Qlik-
View logic. In order to be used in And mode, the following criteria must be fulfilled:
l the field must only exist in one internal table,
l the field must be the second column of no more than two columns, and
l the table must not contain any duplicate records, and
l the table must be loaded using a distinct qualifier. If the table is loaded using a Select statement, a
preceding Load distinct * must be used.
Forced Exclusion/Not Selection
Closely related to the and selection is the forced exclusion, or not selection. Here it is possible to explicitly
exclude a field value, i.e. the solutions found by QlikView may not be associated with the excluded value.
The not selection is made by clicking a cell and keeping the mouse button depressed until the cell turns red.
CTRL-clicking in this manner is equivalent to an exclusion that is an additional requirement to the previous
selections/ exclusions. The not selection can only be made on a field that is in And mode.