Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
juriengroot
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
swuehl
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
sunny_talwar

Try this:


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

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

sunny_talwar

Or you can also use DateField:

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

juriengroot
Contributor III
Contributor III
Author

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

swuehl
MVP
MVP

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

Dates in Set Analysis