Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Liebe Community,
ich habe eine Frage zur Darstellung von Suchergebnissen in einer Listbox.
Ich habe bestimmte Stichworte mit bestimmten Filmtiteln mit Hilfe von Excel assoziiert.
Beispiel:
Leonardo DiCaprio, Daniel Day-Lewis, Martin Scorsese --> Gangs of New York
Leonardo DiCaprio, Tom Hanks, Steven Spielberg --> Catch me if you can
Wenn ich nun nach "Leonardo DiCaprio" suche, werden mir logischerweise beide Filme, also "Gangs of New York" UND "Catch me if you can" angezeigt. Wenn ich nun "Martin Scorsese" als zweite Auswahl eingebe, werden immernoch beide Filme als Ergebnis angezeigt, sozusagen aufsummiert.
Wie bekomme ich es hin, dass nur die Auswahl angezeigt wird, für die BEIDE Stichwörter zutrifft?
Vielen Dank für Eure Hilfe,
Dominic
It sounds like you want "AND-mode". The following is from the QlikView documentation:
Multiple selections within a field are by default interpreted as logical OR, which means that data associated to any of the selected field values will be shown in the other fields.
It is however possible to set list boxes to AND-mode instead. When multiple selections are made in a list box set to AND-mode, only data associated to all of the selected field values will be shown in the other fields.
Example:
Your data source contains information about which customers have purchased different articles.
When you select a couple of articles in the default mode, QlikView will show you the customers that have purchased any of the selected articles.
When you select a couple of articles in AND-mode, QlikView will show you the customers that have purchased all of the selected articles.
The mode for the field is set in List Box Properties: General tab.
When And mode is activated, an ampersand ("&") will be displayed in front of selected values.
If clicking and holding 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 following criteria must be fulfilled:
The following procedure describes how to set a list box in AND-mode instead of the default mode (logical OR). Perform the following steps:
Forced exclusion (sometimes referred to as NOT-selection) is closely related to the AND-selection. The forced exclusion makes it possible to explicitly exclude a field value, which means that the solutions found by QlikView may not be associated with the excluded value.
The forced exclusion is made by clicking a cell and keeping the mouse button pressed 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 forced exclusion can only be made on a field that is in AND-mode.