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
Did you mean:
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)
• Set Analysis

1 Solution

Accepted Solutions
Creator III
Author
`Sum({\$<YEAR=,YEAR= {\$(=YEAR(TODAY())-1)},MONTH={"<=\$(=NUM(Month(today()),'#'))"}>}MOVES)`

4 Replies

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

talk is cheap, supply exceeds demand
Creator III
Author
Getting an error:
) expected

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
Creator III
Author
`Sum({\$<YEAR=,YEAR= {\$(=YEAR(TODAY())-1)},MONTH={"<=\$(=NUM(Month(today()),'#'))"}>}MOVES)`

Tags
Community Browser