topic Logical and between values in the same listbox in QlikView

Logical and between values in the same listbox

Fri, 18 Sep 2009 15:50:34 GMT

Hi all,

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.

Could someone please help me out?

Kind regars
Mi

Logical and between values in the same listbox

Fri, 18 Sep 2009 18:31:26 GMT

Hi Mi,

see the attached example and explanations from QV Help.

Good luck!

Rainer

SV:Re: Logical and between values in the same listbox

Fri, 18 Sep 2009 19:10:14 GMT

Thanks Rainer for your reply!

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

Logical and between values in the same listbox

Fri, 18 Sep 2009 19:48:13 GMT

Mi,

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

Hope this helps!

Rainer

SV:Re: Logical and between values in the same listbox

Fri, 25 Sep 2009 17:51:38 GMT

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.

Thanks for taking your time to help me though!

Kind regards

Logical and between values in the same listbox

Fri, 25 Sep 2009 18:19:57 GMT

Hello Mi,

thank you for letting me know what the status is!

Have a nice weekend.

Rainer

SV:Re: Logical and between values in the same listbox

Fri, 04 Dec 2009 08:54:00 GMT

Hi Mi Ta,

We're are having the same issue here. Anything you could share on this would be much appreciated.

Thanks!