Discussion board where members can get started with QlikView.
I just want to omit this year 1900 in my Date field.
where not Match(Year, '1900');
View solution in original post
Do it in the scrip while you are loading them
Where Year(Date) <> 1900;
Hahahaha your solution showed me my mistake, I was doing = 1900 instead of <> 1900
haha no worries
Try like this
Load * from datasource where Year(Date) <> 1900;