topic Re: Year wise Last month Sales in QlikView

Year wise Last month Sales

sreeni_qvd — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I wrote this expression, If select any year, I am getting complete month wise sales (Possible months).

Sum({$<Year = P({1<Year={$(=Only(Year))},MonthNo ={$(=max(MonthNo))}>})>}Sales)

But I am expecting. If I select any Year, In that year what is the last month Sales only.

Regards:

Sreeni

Re: Year wise Last month Sales

PrashantSangle — Wed, 27 Apr 2016 12:55:04 GMT

Hi,

Try,

Sum({<MonthNo={"$(=max(MonthNo))"}>}Sales)

Kind Regards

Re: Year wise Last month Sales

sunny_talwar — Wed, 27 Apr 2016 12:55:57 GMT

Have you tried this:

Sum({$<MonthNo ={$(=Max(MonthNo))}>}Sales)

Re: Year wise Last month Sales

MK_QSL — Wed, 27 Apr 2016 12:58:39 GMT

=SUM({<InvoiceYear = {'$(=Max(InvoiceYear))'}, InvoiceMonth = {"$(=Month(MakeDate(Max(InvoiceYear),Max({<InvoiceYear = {'$(=Max(InvoiceYear))'}>}InvoiceMonth))))"}>}Sales)

Chagne InvoiceYear and InvoiceMonth to your respective field names.

Re: Year wise Last month Sales

sasikanth — Wed, 27 Apr 2016 13:01:32 GMT

try some thing like,

create YearMonth field and use that field in set expression

sum({<YearMonth={$(=max(YearMonth))}>} Sales)