Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
MVP
MVP

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])

View solution in original post

5 Replies
Highlighted

Try this:


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

Highlighted
MVP
MVP

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])

View solution in original post

Highlighted

Or you can also use DateField:

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

Highlighted
Contributor III
Contributor III

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

Highlighted
MVP
MVP

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

Dates in Set Analysis