Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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)