Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

Set analysis for the sum of a field not affected by selector and explicit and less than selections

I have an expression:

 

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={$(=NUM(Month(today()),'#'))}>}MOVES)

Which gives me the SUM of MOVES from 2018 and Month 6

What i want is the SUM of MOVES from 2018 MONTHs 1 to 6.

I tried:

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH<={$(=NUM(Month(today()),'#'))}>}MOVES)

But it isnt returning anything

Labels (1)
1 Solution

Accepted Solutions
matthewp
Creator III
Creator III
Author

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#'))"}>}MOVES)

 

View solution in original post

4 Replies
Gysbert_Wassenaar

close, but try this:
Sum({$<YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#')"}>}MOVES)


talk is cheap, supply exceeds demand
matthewp
Creator III
Creator III
Author

Getting an error:
) expected
Gysbert_Wassenaar

Cool, you have a learning opportunity here. Try to figure out what's wrong and then fix it.

Hint: it has to do with the parentheses.


talk is cheap, supply exceeds demand
matthewp
Creator III
Creator III
Author

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#'))"}>}MOVES)