Qlik Sense exclude specific data from loading

[bryan_21]

Hello, how can I exclude the year 2017-2020 data from my table before loading. See below.

LOAD
     YEAR,
     MONTH,
     DAY
     FROM [lib://QVDs/A/CS.QVD]
(qvd);

The YEAR has 2017 to 2022 data but I would like to get the 2021 to 2022 only.

Thank you!

[Lisa_P · Accepted solution]

LOAD
     YEAR,
     MONTH,
     DAY
     FROM [lib://QVDs/A/CS.QVD]
(qvd)

where YEAR >2020;

[Alagumurugan · Accepted solution]

LOAD
YEAR,
MONTH,
DAY
FROM [lib://QVDs/A/CS.QVD]
(qvd)
where match(year,'2021','2022');

[BrunPierre · Accepted solution]

Maybe you want it to be dynamic, so try this

LOAD * FROM [lib://QVDs/A/CS.QVD](qvd)

Where YEAR >= Year(AddYears(YearStart(Today()),-1));

[bryan_21]

Thank you for the prompt response guys.