Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've below script.
2 expressions can resolve your case :
With the field "Date"
Sum({$<Date = {">=$(=YearStart(Today())) <=$(=Today())"}>} Sales)
With the field "DateFormatted"
Sum({$<DateFormated = {">=$(=Date(YearStart(Today()),'DD/MM/YYYY')) <=$(=Date(Today(),'DD/MM/YYYY'))"}>} Sales)
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
I think its because this date and data is actually tomorrow
02/23/2024, 700
it falls outside your set analysis modifier, if you run it today, February 22 2024.
">=$(=Date(YearStart(Today()))) <=$(=Date(Today()))"