Values in grey on a list box appears as selected in the current selections box
Article Number: 000038330 | Last Modified: 2019/01/24
How can it be that in the screenshot below the value 'A' is in grey in the listbox but is selected in the current selections box?
The value 'A' is selected but not possible (since it is has been excluded when selecting 'b'). Values like 'A' in the example are not green in the list box since they are not possible but they are still selected even though they are also excluded. They are in a state called 'Selected Excluded' and therefore they are selected they show as such in the current selections box.
This is very easy to accomplish and it happens all the time when using Qlikview that values in grey as seen in the correct selection box as selected.
Lets create a QlikView document and load the following piece of script:
load * inline [
Field_1, Field 2
Lets create two list boxes, one for each existing field and a current selections box.
If we now select the values 'A' and 'B' in the list box for Field_1 and then select the value 'b' in the other list box we recreate the situation in the picture.