change x axis in a line chart

[Manuel174102]

hello people, 

i made a similar post today, but i want to see what choices there are out there. 

i have a line chart showing sales per year, and it is dropping in 2022, clearly, because the year is not over.

in the x axis, you can see the years: 2017,2018,2019,2020,2021 and 2022. Instead of 2022, I would like to have "Till Today" or "Till present"

can i do that? 

thanks in advance

[SchalkF]

Hi, you should be able to do this with a normal If function in your dimension:

if(YearDim = '2022', 'Till Today', YearDim)

Kind regards

[Manuel174102]

do you probably know what would be the answer to this question?

How to project the rest of the days of the year in... - Qlik Community - 1984087