topic Re: Multiple NOT selections not working in QlikView

Multiple NOT selections not working

shyamcharan — Mon, 08 May 2017 05:31:34 GMT

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.

Re: Multiple NOT selections not working

tresB — Mon, 08 May 2017 05:43:55 GMT

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

Re: Multiple NOT selections not working

shyamcharan — Mon, 08 May 2017 06:03:24 GMT

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.