Filter in the data load editor

[Nemo1]

Hello everyone.. 

I am trying to do the following but it doesnt work. I want to filter out the Q1 from 2022.. the code looks like that

The column Year is filled with data in this fashion: 2020,2021,2022,2023,2024, 2021 Q1, 2021 Q2, 2022 Q4, etc.. 

Data:
LOAD

         Sales,

         Costs,

         Year,

         Stores

FROM [lib://Reports/2021/finalreport.qvd]
(qvd)
where Year <> "2022 Q1";

thanks

[Clement15]

Hello,

Do you have an example of your data, including those of your date fields that you want to filter

[JordyWegman · Accepted solution]

Hi Nemo,

First we need to know if in the source Finalreport.qvd the field Year is available.

If it's so, and there is 2022 Q1, you need to apply single quotes, not double.

Data:
LOAD

         Sales,

         Costs,

         Stores

FROM [lib://Reports/2021/finalreport.qvd]
(qvd)
where Year <> '2022 Q1';

Jordy

Climber

[Nemo1]

it did work, thanks!