Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juriengroot
New Contributor III

Set analysis smaller than current Month

  Hi,

I am trying to get Sales smaller than current month.

Below works fine for current month.

Sum({$<Month={'$(=Month(Today()))'}>}[Sales])

When adding:

Sum({$<Month={<='$(=Month(Today()))'}>}[Sales])


It doesn't work. I tried so many variations..


Some help would be very much appreciated!

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis smaller than current Month

What is the format of your month field?

Try creating a numeric month field

LOAD

     Month(Date) as Month,

     Num(Month(Date)) as MonthNum,

     ...

Then

Sum({$<MonthNum ={"<=$(=Num(Month(Today())))"}>} [Sales])

5 Replies

Re: Set analysis smaller than current Month

Try this:


Sum({$<Month={'<=$(=Month(Today()))'}>}[Sales])

MVP
MVP

Re: Set analysis smaller than current Month

What is the format of your month field?

Try creating a numeric month field

LOAD

     Month(Date) as Month,

     Num(Month(Date)) as MonthNum,

     ...

Then

Sum({$<MonthNum ={"<=$(=Num(Month(Today())))"}>} [Sales])

Re: Set analysis smaller than current Month

Or you can also use DateField:

Sum({$<Month={"$(='<' & Date(MonthStart(Today()), 'DateFieldFormatHere'))"}>} [Sales])

juriengroot
New Contributor III

Re: Set analysis smaller than current Month

Thanks, does Qlik not understand the expression without nummeric value? Kind of strange, no?

MVP
MVP

Re: Set analysis smaller than current Month

Yeah, could be kind of confusing / strange, see also the comments below

Dates in Set Analysis

Community Browser