Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
its often ask but somehow still not working:
Sum({<[Date.Dispatch.autocalendar.Date]={"$(=month(today))"}>}[Dispatch.Value])
I want to display the dispatch value of the current month. Simply straightforward but still didn't work out so far.
Is it maybe because I cannot equal the autocalendar.Date to the month(today) DSE-functions?
Big thanks in advance.
Best.
Yes. make sure the format in set expression is same as the format in column
you should not use [Date.Dispatch.autocalendar.Date] field. you should use month field in your auto calendar.
but do you want current month year? above will give you sum of dispact values for all octobers (regardless of year)
if so you need a field called month year in your auto calendar and date(monthstart(today()), 'MMM-YYYY').
i would recommend you move away from auto calendar and use a master calendar you create using script. it will give you more flexibility
https://qlikviewcookbook.com/2015/05/better-calendar-scripts/
Hello @dplr-rn ,
thanks for the link you providing. I will look into the mastercalendar.
But back to what I have now just for a understanding:
would Date.Dispatch.autocalendar.YearMonth or
Date.Dispatch.autocalendar.Month and equal it with your mentioned function" date(monthstart(today()), 'MMM-YYYY')" in a set expression/set analysis like before?
Best.
Yes. make sure the format in set expression is same as the format in column