Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
danaleota
New Contributor II

Excluding many values in a column don't want to use a bunch of where and's

Hi,

I would like to load a table that has a column - Years and there are many values of years I don't want to include.  Instead of writing:

Where Year <>  1800 And Year <> 1801 And Year <> 1802 And Year <> 1803 

Is there a faster way to write this out in a statement?  Thank you.  

1 Solution

Accepted Solutions

Re: Excluding many values in a column don't want to use a bunch of where and's

You can do this

Where Year >= 1804;

or

Where not Match(Year, 1800, 1801, 1802, 1803,...);

View solution in original post

2 Replies

Re: Excluding many values in a column don't want to use a bunch of where and's

You can do this

Where Year >= 1804;

or

Where not Match(Year, 1800, 1801, 1802, 1803,...);

View solution in original post

danaleota
New Contributor II

Re: Excluding many values in a column don't want to use a bunch of where and's

Ah thank you!