topic How to make a NOT selection (red) in QlikView

How to make a NOT selection (red)

dirk_konings — Fri, 20 Nov 2009 16:38:51 GMT

How can i make a NOT selection (red selection)

How to make a NOT selection (red)

Fri, 20 Nov 2009 16:47:56 GMT

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,

How to make a NOT selection (red)

dirk_konings — Fri, 20 Nov 2009 16:55:58 GMT

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

see help for 'color sheme'

How to make a NOT selection (red)

Fri, 20 Nov 2009 17:02:07 GMT

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

How to make a NOT selection (red)

dirk_konings — Fri, 20 Nov 2009 17:06:49 GMT

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)

How to make a NOT selection (red)

Fri, 20 Nov 2009 17:16:57 GMT

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

How to make a NOT selection (red)

dirk_konings — Fri, 20 Nov 2009 17:17:20 GMT

I found it :

And-mode in List Boxes

http://community.qlik.com/blogs/qlikviewblogs/archive/2009/11/08/and-mode-in-list-boxes.aspx

How to make a NOT selection (red)

dirk_konings — Fri, 20 Nov 2009 17:17:58 GMT

i just found it too !!