Show date range in sheets

[Sebastian_Dec]

Hi, how show date range in charts in Qlik Enterprise?

I have function =CYTD.Text that only show current year range.
But if I chose 2020/2021/2023 I have only last year:
2020/2021/2023 -> 2023
2020/2021 -> 2021

I need do show all date range that I chose.

[marcus_sommer · Accepted solution]

Some ideas for flags within the master-calendar:

-(daynumberofyear(datefield)<=daynumberofyear(today())) as YTD,
year(today()) - year(datefield) as YearOffset

[Sebastian_Dec]

Thx, I use master calendar and make KPI with date:

Min(Data)

Max(Data)