topic Re: MonthYear issue in Qlik Automate

MonthYear issue

nagarajuchilveri — Tue, 30 Apr 2024 11:49:43 GMT

Hi Guys,

I need a help,

below snapshot,

Here I have taken from start month to till month,but I need previous month(Mar-24).

I have used formula 1st YTD:

=Num((Sum({< [DATE OF ISSUE1] = {">=$(=( YearStart(now(),0,7) )) <$(=( YearEnd(now(),0,7) ))"}>} Tkts)),'##,###,###')

for previous month I have used below formula:

vStartMonth=Date(AddMonths(Min([DATE OF ISSUE]), 0), 'MMM-YY')

vPreviousMonth=Date(AddMonths(Max([DATE OF ISSUE]),-1),'MMM-YY')

=Num((Sum({< Month1 = {">=$(=(vStartMonth))<=$(=(vPreviousMonth))"}>} Tkts)),'##,###,###')

This is not working. I need to remove Apr-24 month. I have applied condition in dimension also still not working.is

How to resolve this issue.

Regards,

Nagaraju

BrunPierre — Tue, 30 Apr 2024 11:51:31 GMT

Try

=Sum({<Month = {"$(=Date(MonthStart(Max(Month), -1), 'MMM-YY'))"}>} Tickets)

nagarajuchilveri — Tue, 30 Apr 2024 11:56:16 GMT

I tried, but it's not working

=Sum({<Month = {"$(=Date(MonthStart(Max(Month), -1), 'MMM-YY'))"}>} Tkts)

BrunPierre — Tue, 30 Apr 2024 11:57:19 GMT

Format the month as such in the script.

Date#(Month,'MMM-YY') as Month

nagarajuchilveri — Tue, 30 Apr 2024 12:12:11 GMT

I got below like this

I need Jul-23 to Mar-24,Then I have used below expression

=Num(Sum({<Month = {">=$(=Date(MonthStart(Min(Month), 0), 'MMM-YY'))<=$(=Date(MonthStart(Max(Month), -1), 'MMM-YY'))"}>} Tkts),'##,##')

but not working.

BrunPierre — Tue, 30 Apr 2024 13:05:30 GMT

Perhaps.

=Sum({<Month={">=$(=min(Month))<=$(=Max( Month)-1)"}>} Tkts)

nagarajuchilveri — Fri, 03 May 2024 11:39:17 GMT

It's working

Previous month is showing.