Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adam_tate
New Contributor II

Set Analysis Month Query

Hi,

I am trying to get a sum of the amount of lines sold for this current month using set analysis  with the following:

SUM({$<Month([Order Date]) = {month(today())}>} [Line Amount])

I am getting errors, any ideas?

Thanks in advance

3 Replies
shraddha_g
Honored Contributor III

Re: Set Analysis Month Query

Sum({<[Order Date] = {">=$(=Date(MonthStart(max([Order Date))))<=$(=Date(Max([Order Date])))"}>}[Line Amount])

shraddha_g
Honored Contributor III

Re: Set Analysis Month Query

You can also create month field in Script as

Monthname([Order Date]) as Month

Use this in Set Analysis

Sum({<Month = {"$(=Maxstring(Month))"}>}[Line Amount])

adam_tate
New Contributor II

Re: Set Analysis Month Query

Thankyou for your help, worked perfectly

Community Browser