Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New Contributor III

Max Date Month

Hi,

I Want to sum MAX MONTH DATE with date field. I use This formula

sum({<Month={'$(=Month(max(Date)))'}>}Volume) and It does not work can you please Tell me What to do?

1 Reply

Re: Max Date Month

SUM({<Month = {"$(=Month(Max(Date)))"}>}Volume)

or

SUM({<Month = {"$(=Month(Max({1}Date)))"}>}Volume)

or

SUM({<Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))"}>}Volume)

or

SUM({<Date = {">=$(=MonthStart(Max({1}Date)))<=$(=MonthEnd({1}Max(Date)))"}>}Volume)

I am assuming that Month field is having same format as the MonthNames variable's month format.

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';