topic Re: Qlik Sense exclude specific data from loading in App Development

Qlik Sense exclude specific data from loading

bryan_21 — Tue, 13 Sep 2022 03:38:14 GMT

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 — Tue, 13 Sep 2022 04:00:21 GMT

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

where YEAR >2020;

Alagumurugan — Tue, 13 Sep 2022 05:27:20 GMT

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

BrunPierre — Tue, 13 Sep 2022 06:12:01 GMT

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 — Tue, 13 Sep 2022 09:17:37 GMT

Thank you for the prompt response guys.