topic Select Statement using NOT IN in QlikView

Select Statement using NOT IN

Wed, 03 Nov 2010 15:17:31 GMT

Can anyone explane to me how i can use the NOT IN function in my where clause? I want to exclude multiple values from loading..

thank you!!!!

Wed, 03 Nov 2010 15:31:33 GMT

Hi,

You can use the function NOT EXISTS in your scripts.

hector — Wed, 03 Nov 2010 15:38:46 GMT

Hi, you can use match() which essentially is the same as an "IN" clause in SQL Server, as well you can use not match()

SQL Version

Field in ('A','B','C') OR
Field not in ('F')

QV Version
match (Field,'A','B','C') OR
not match (Field,'F')

Rgds