Choosing multiple values in one listbox is interpreted as a "logical or" between the values, but is it possible to get a "logical and" instead? What I want to do is show all patients with a combination of certain diagnosis.
For some reason the setting for "And logic" isn't available for me to choose, even though I got administrator's rights. Also in the same listbox I would like to still be able to do some "OR" while doing some "AND" between the values in one listbox. Perhaps this is possible while changing the settings to "And logic"...
read carefully the strict conditions for a LISTBOX you will use in AND-mode. The AND-mode check box is only available if the conditions are fulfilled. It has nothing to do with admin rights or so.
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.)
I met the conditions stated for AND-logic in a listbox but however this didn't solve my problem, cause I still couldn't use logical AND and logical OR in one listbox. I had to solve it by using bookmarks and a macro.
