Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to exclude unwanted year in Date field.

Hi,

I just want to omit this year 1900 in my Date field.

exasdf.PNG

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: How to exclude unwanted year in Date field.

Try:

where not Match(Year, '1900');

Thanks,

AS

View solution in original post

5 Replies
Highlighted

Re: How to exclude unwanted year in Date field.

Do it in the scrip while you are loading them

LOAD Date,

          otherFields

FROM xyz

Where Year(Date) <> 1900;

Highlighted
Master III
Master III

Re: How to exclude unwanted year in Date field.

Try:

where not Match(Year, '1900');

Thanks,

AS

View solution in original post

Highlighted

Re: How to exclude unwanted year in Date field.

Hahahaha your solution showed me my mistake, I was doing = 1900 instead of <> 1900

Highlighted
Master III
Master III

Re: How to exclude unwanted year in Date field.

haha no worries

Highlighted

Re: How to exclude unwanted year in Date field.

Hi

Try like this

Load * from datasource where Year(Date) <> 1900;