If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm trying to calculate the first day of work of the current year for a filtered sales rep. To do so, I need to find the date of his/her first sale of the year.
Using the following formula the system returns me a wrong date.
ES: min(date($(=year(today()))), sales_ID)
Forcing the year to "2020" it returns me the same result as above.
ES: min(date($(=year('2020'))), sales_ID)
Where did I go wrong?
Thanks in advance for any help!