Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
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 (2)
1 Solution

Accepted Solutions
matthewp
Creator III
Creator III

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

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

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

 

View solution in original post