topic Show date range in sheets in App Development

Show date range in sheets

Sebastian_Dec — Thu, 26 Jan 2023 10:14:16 GMT

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.

Re: Show date range in sheets

marcus_sommer — Thu, 26 Jan 2023 13:28:46 GMT

Some ideas for flags within the master-calendar:

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

Re: Show date range in sheets

Sebastian_Dec — Mon, 27 Mar 2023 12:56:27 GMT

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

Min(Data)

Max(Data)