Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to make a NOT selection (red)

How can i make a NOT selection (red selection)

1 Solution

Accepted Solutions
Highlighted
Not applicable

Right, got it now, there is a help section as below, but it appears from this that the conditions under which this is available are very strict.

And-mode in List Boxes

A multiple selection within a field is by default interpreted as logical OR, which means that data associated to any of the selected field values will be shown in other fields. It is however possible to set certain list boxes to AND-mode instead. When you make multiple selections in a list box set to AND-mode, the associations in other fields must be to all selected values, which is exactly how associations are normally made to multiple selections in several fields.

When AND-mode is activated, an ampersand ("&") will be displayed in front of selected values.

If you click and hold a value for a moment, the selection will switch from (AND) selected (green) to NOT selected (red). The ampersand will also be replaced by an exclamation mark ("!"). The NOT selection which is a forced exclusion of the value or values so marked, can only be made when a list box is in AND-mode.

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 QlikView logic. In order to be used in AND-mode, the following criteria must be fulfilled:

  • the field must only exist in one logical table,

  • this table must only contain two fields,

  • the field must be the second column,

  • the table must not contain any duplicate records, and

  • the table must be loaded using a Load distinct … (If the table is loaded using a Select distinct … statement, this must be preceded by a Load distinct * ; statement.)

View solution in original post

7 Replies
Highlighted
Not applicable

If you make a single selection in a list box, you can then right click and "Select Excluded" which is effectively the same thing as your suggesting. I'm not sure if there's another way to do this as I've never needed it!

Good luck,

Highlighted
Creator III
Creator III

That's not what i need. A normal selection is green, i want to do a RED selection.

see help for 'color sheme'

Highlighted
Not applicable

Ahhh now I understand.

I have asked this question of QlikTech before and the answer is that you cannot change it, they didn't have a good reason apart from stating that "Selections should be in green, Not selected should be white, Not available should be grey" there is no way I have managed to change this but I know they planned to allow this in version 9 (I'm using V8.5).

Highlighted
Creator III
Creator III

no, i meen that you can make a selection on let's say customers that didn't by that specific product. This selection should automatically be colored red (see help)

Highlighted
Not applicable

Right, got it now, there is a help section as below, but it appears from this that the conditions under which this is available are very strict.

And-mode in List Boxes

A multiple selection within a field is by default interpreted as logical OR, which means that data associated to any of the selected field values will be shown in other fields. It is however possible to set certain list boxes to AND-mode instead. When you make multiple selections in a list box set to AND-mode, the associations in other fields must be to all selected values, which is exactly how associations are normally made to multiple selections in several fields.

When AND-mode is activated, an ampersand ("&") will be displayed in front of selected values.

If you click and hold a value for a moment, the selection will switch from (AND) selected (green) to NOT selected (red). The ampersand will also be replaced by an exclamation mark ("!"). The NOT selection which is a forced exclusion of the value or values so marked, can only be made when a list box is in AND-mode.

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 QlikView logic. In order to be used in AND-mode, the following criteria must be fulfilled:

  • the field must only exist in one logical table,

  • this table must only contain two fields,

  • the field must be the second column,

  • the table must not contain any duplicate records, and

  • the table must be loaded using a Load distinct … (If the table is loaded using a Select distinct … statement, this must be preceded by a Load distinct * ; statement.)

View solution in original post

Highlighted
Creator III
Creator III

Creator III
Creator III

i just found it too !!