Discussion board where members can get started with Qlik Sense.
I have a fiscal calendar starting October 1. st.
How can I make a flag field which flags all dates in "YearToDate" for current and all previous years.
When I use this formula, it only flags the dates from 2018 October 1. to current day (2019 January 12.)
if(InYearToDate(Date,today(),0,10),1,0) as YTD
I want to flag all dates for October 1. to January 12, in all previous years in my calendar.
Whit my normal calendar I can do this with:
if (DayNumberOfYear(Date) <= DayNumberOfYear(Today()), 1, 0) as YTD
Go to Solution.
Thanks, but it only flags the dates in previous fiscal year (dates from 2017 October 1. to 2018 January 12.).
My calendar begins in 1999, and for each fiscal year, I want to flag the dates from October 1. to January 12. (= ToDay() ).
Thank you, it works fine.