there are some pretty strict requirements for the use of and-mode in list boxes.
From the 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 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,
- the field must be the second column of no more than two columns, and
- the table must not contain any duplicate records, and
- the table must be loaded using a distinct qualifier. If the table is loaded using a Select statement, you must use a preceding Load distinct *.
Do your setting fulfills all these requirement?
Thanks for the swift response.
I have now got the process working on a simple test, loading two test fields from a spreadsheet, so can make the tick box available. However my live data is more complex and doesnt meet the strict rules above - I can manage everything except the no duplicates constriant, and that is legitimate duplication as uniqeness is based on four indexes and it appears I can only bring in two fields.
I feel there must be an alternative solution but cant spot anything in the user help.
the restrictions (i.e. two fields only) are related to the table of which the and-mode field is coming from. You could link the first column to other tables, if that is from any help.
You could also create a unique field by using QlikViews functions in the load script, like concat() or autonumber, for concatanating some fields and/or creating a unique ID.
Maybe you could post a little more details about your data model, if possible you might post also a small sample application here (upload available in advanced editor).
I've also just found that thread: http://community.qlik.com/message/127398#127398 , maybe that's of any help, too.