Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
You can do this
Where Year >= 1804;
Where not Match(Year, 1800, 1801, 1802, 1803,...);
View solution in original post
Ah thank you!