topic Re: Exclude some records when loading script in QlikView

Exclude some records when loading script

anuradhaa — Tue, 09 Feb 2016 09:04:21 GMT

I want to exclude vales when loading script.

I know i can use match() but i want to exclude 3 values. is there any negative function for match

Re: Exclude some records when loading script

Chanty4u — Tue, 09 Feb 2016 09:05:55 GMT

Hi,

use a WHERE NOT EXISTS() clause in the LOAD to exclude those?

Re: Exclude some records when loading script

kaushiknsolanki — Tue, 09 Feb 2016 09:07:06 GMT

Kindly Give example to explain your problem.

Regards,

Kaushik Solanki

Re: Exclude some records when loading script

MK_QSL — Tue, 09 Feb 2016 09:07:51 GMT

TableName:

Load Customer, Sales, Date, InvoiceNumber From SalesTable

Where Not Match(Customer, 'A','B','C');

Something like above..

Re: Exclude some records when loading script

jonathandienst — Tue, 09 Feb 2016 09:08:13 GMT

To exclude values

Where Match(field, 'ValuetoExclude') = 0

Where Not(Match(field, 'ValuetoExclude')) // if that is more readable

Re: Exclude some records when loading script

avinashelite — Tue, 09 Feb 2016 09:09:20 GMT

if you have only 3 values than use the where clause

like

LOAD

from

table

where A='value1' or A='value2' or A='value3' ;

or if you have multiple fields than

where A='value1' and B='value2' and C='value3'

Re: Exclude some records when loading script

Chanty4u — Tue, 09 Feb 2016 09:10:02 GMT

use

sampl:

Load

cust as CustomerTab

Resident sales

where not exists ([Name], [age],[salary]);

Re: Exclude some records when loading script

sunny_talwar — Tue, 09 Feb 2016 09:10:27 GMT

You can use not Match()

Re: Exclude some records when loading script

jagan — Wed, 10 Feb 2016 03:52:37 GMT

Hi,

Always use Mixmatch() so even if there is any upper/lower casing differences then also it works.

Note: Qlikview is case sensitive. A and a is not the same in Qlikview.

Where Not MixMatch(Customer, 'A','B','C');

Hope this helps you.

Regards,

Jagan.