Multiple NOT selections not working

[shyamcharan]

Hi Experts,

I am trying to achieve AND selections and NOT selections.

I found a solution in the below link. However, Multiple values with AND condition works but Multiple values with NOT condition does not work. NOT works only with one value.

And-Mode: How to enable AND and NOT selections with Green, White, Grey...and Red!

AND selections works.

If I would want to see a patient who had drugs Drug2 AND Drug5, it works fine

NOT selections works only with one value as NOT but does not work with multiple values.

Exaple:

If I want a patient who has taken Drug2 but NOT Drug5 it works

If I want a patient who has taken Drug2 but NOT DRUG3 AND Drug5 it doest not work. Looks  like andMode list box not allowing me multiple value selection for NOT

I want the NOT selection to be worked with any number of values selected.

Please help.

[tresesco]

Multiple NOTs are working, only thing is your combination that you are trying is logically not possible it seems.

[shyamcharan]

HI Tresesco.

Thanks for your response.

I am not able to get a selection like below:

Patients with Drug2 but not Drug4 AND Drug5.

In this case I should get no patients as result. Doesn't it work?

Sam            Peter          John          Antony

Drug1          Drug4          Drug2        Drug2

Drug2          Drug5          Drug5        Drug4

Drug3                                              Drug5

Drug4

Also, just wondering if these selections can be actions of any button?

I do have a few old users who may not be able to go good with the NOT selections. Can I achieve my requirement using buttons?

Thanks in advance

Regards,

Shyam.