topic Re: Exclude All except some in QlikView

Exclude All except some

wcilliers — Tue, 09 May 2017 11:17:50 GMT

Hi All,

I have two scenarios that I need help with.

Scenario 1:

I need to exclude billing types A and B, but only from 01/04/2017, all transactions before that still has to be included. Preferably, I dont want to load twice if it is not necessary, was hope there is an easy way to structure the where clause....

Scenario 2:

I need to exclude all ITEMCODES starting with ABC, except ABC1, ABC4, ABC12.

Again, I would like to do this in a where clause if possible.

Any help would be greatly appreciated.

Thanks,

Wynand

Re: Exclude All except some

Anil_Babu_Samineni — Tue, 09 May 2017 11:23:59 GMT

Scenario-1:

May be this?

Load * From Table Where Not Match([billing types],'A', 'B') and Transactions = '01-04-2017';

Load * From Table Where [billing types] <> 'A' and [billing types] <> 'B' and Transactions = '01-04-2017';

Scenario-2:

You need except ABC1 ... But, You have starting with ABC only. Would you provide some inputs may be data and tell us result you want to see

Re: Exclude All except some

tamilarasu — Tue, 09 May 2017 11:26:57 GMT

Hi Wynad,

Try something like below..

Scenario 1:

Load *

From

Source

Where (Date >= '01/04/2017' And Not Match([Billing Type],'A','B') ) OR (Date <'01/04/2017') ;

Scenario 2:

Load *

From

Source

Where Wildmatch(ITEMCODES, 'ABC*) And Not Match(ITEMCODES,'ABC1','ABC4','ABC12');

Re: Exclude All except some

wcilliers — Tue, 09 May 2017 12:07:05 GMT

Hi Tamil,

Thank you.

Scenario 1:

I added the OR part which forgot to add initially and it now works. Thanks!

Scenario 2:

Has to be the other way around.

I swapped it around a bit and used your logic from Scenario 1 and it works...

Where

Match(ItemCode,'ABC1','ABC4','ABC12')

NOT Wildmatch(ItemCode, 'ABC*')

Thanks for the help All!!

Much Appreciated!

Re: Exclude All except some

tamilarasu — Tue, 09 May 2017 13:11:10 GMT

Great Wynand!! Have a good day!