Remove a specific year from a list of years

[paulo_cunha]

Hello, everybody.

I'm trying to do a simple thing in Qlik Sense. I just want to remove a specific year from a list with years, like:

2023

2022

2021

2020

I'm trying to remove the year of 2023. I tried to use the following code:

=if([Moth_Year.autoCalendar.Year]=2023,"NULL" , [Month_Year.autoCalendar.Year])

Where Month_Year has the following data:

03/2023 (Month/Year)

02/2023

01/2023

03/2022

02/2022

01/2022

03/2021

02/2021

01/2021

03/2020

02/2020

01/2020

But the code I'm using isn't working properly. So I just would like to look for help to try to solve this problem.

Att,

Paulo

[Bunim · Accepted solution]

Try this -

aggr(only({<Month_Year -={'*2023*'}>}Month_Year ),Month_Year )

[BrunPierre · Accepted solution]

The null syntax is "Null()", perhaps this is what you want

=If(WildMatch([Moth_Year.autoCalendar.Year],'*2023*'), null(), [Moth_Year.autoCalendar.Year])

Hope this helps!