topic Re: KPI Window: return sum of this month value in App Development

KPI Window: return sum of this month value

Applicable88 — Thu, 29 Oct 2020 15:36:13 GMT

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.

Re: KPI Window: return sum of this month value

dplr-rn — Thu, 29 Oct 2020 18:41:39 GMT

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/

Re: KPI Window: return sum of this month value

Applicable88 — Thu, 29 Oct 2020 19:47:59 GMT

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.

Re: KPI Window: return sum of this month value

dplr-rn — Thu, 29 Oct 2020 19:50:37 GMT

Yes. make sure the format in set expression is same as the format in column