Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Exclude some records when loading script

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Exclude some records when loading script

TableName:

Load Customer, Sales, Date, InvoiceNumber From SalesTable

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

Something like above..

View solution in original post

8 Replies
Highlighted
Champion III
Champion III

Re: Exclude some records when loading script

Hi,

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Exclude some records when loading script

Kindly Give example to explain your problem.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
MVP
MVP

Re: Exclude some records when loading script

TableName:

Load Customer, Sales, Date, InvoiceNumber From SalesTable

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

Something like above..

View solution in original post

Highlighted

Re: Exclude some records when loading script

To exclude values

     Where Match(field, 'ValuetoExclude') = 0

or

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Re: Exclude some records when loading script

if you have only 3 values than use the where clause

like

LOAD

A,

B,

C,

D

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'

Highlighted
Champion III
Champion III

Re: Exclude some records when loading script

use

sampl:

Load

*,

cust as CustomerTab

Resident sales

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

Highlighted

Re: Exclude some records when loading script

You can use not Match()

Highlighted
MVP & Luminary
MVP & Luminary

Re: Exclude some records when loading script

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.