Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jdmarlin
Contributor III
Contributor III

Less than/greater than in set analysis

Hello

I thought this would be quite straight forward but this expression doesn't aggregate between January and the maximum MONTH of the YEAR.

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(=vMaxMonth)"}>} ACTIVITY)

This expression, however, works:

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=7"}>} ACTIVITY)

1 Solution

Accepted Solutions
jdmarlin
Contributor III
Contributor III
Author

Nevermind.. adding a '#' made it work

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(#=vMaxMonth)"}>} ACTIVITY)

View solution in original post

1 Reply
jdmarlin
Contributor III
Contributor III
Author

Nevermind.. adding a '#' made it work

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(#=vMaxMonth)"}>} ACTIVITY)