topic Re: Exclude within script, except for... in QlikView

Exclude within script, except for...

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

I need to exclude Account# 5306510 but only for Department# CC235, otherwise I want to include it.

I only know how to exclude account numbers as seen below.

Where T$OYER >=2014 and not WildMatch(T$LEAC, '5706710','5706730','5706750','5706770','5849990','5839991','3100100','4101100','5839990','5306505','5306515','5805985','5829990','5805954','5805950','5255830');

Re: Exclude within script, except for...

maxgro — Wed, 19 Oct 2016 18:44:10 GMT

where

not

( Account# = 5306510 and Department# = 'CC235')

Re: Exclude within script, except for...

sunny_talwar — Wed, 19 Oct 2016 19:21:58 GMT

or you can do thos:

Where Account# <> 5306510 or Department# <> ''CC235';

Re: Exclude within script, except for...

maxgro — Wed, 19 Oct 2016 19:38:52 GMT

not (X and Y) becomes (not X or not Y)

Re: Exclude within script, except for...

sunny_talwar — Wed, 19 Oct 2016 19:41:05 GMT

Right, did I miss something by mistake or are you just explaining the logic to the OP

Re: Exclude within script, except for...

maxgro — Wed, 19 Oct 2016 19:58:31 GMT

I was explaining to myself. I must admin I forgot the boolean algebra and I had to think a little to remember your answer and mine answer are the same.

Re: Exclude within script, except for...

sunny_talwar — Wed, 19 Oct 2016 20:05:29 GMT

Yes I replicated your response by twisting it around

Re: Exclude within script, except for...

Peter_Cammaert — Wed, 19 Oct 2016 20:53:55 GMT

I think you should split the rewards

Re: Exclude within script, except for...

sunny_talwar — Wed, 19 Oct 2016 20:55:38 GMT

I think maxgro‌‌ deserves it

Re: Exclude within script, except for...

fanninam — Wed, 19 Oct 2016 22:29:56 GMT

Thank you Massimo! This worked!