Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

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
MK_QSL
MVP
MVP

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
Chanty4u
MVP
MVP

Hi,

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Kindly Give example to explain your problem.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
MK_QSL
MVP
MVP

TableName:

Load Customer, Sales, Date, InvoiceNumber From SalesTable

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

Something like above..

jonathandienst
Partner - Champion III
Partner - Champion III

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
avinashelite

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'

Chanty4u
MVP
MVP

use

sampl:

Load

*,

cust as CustomerTab

Resident sales

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

sunny_talwar

You can use not Match()

jagan
Luminary Alumni
Luminary Alumni

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.