# New to Qlik Sense

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

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## Set analysis - from the beginning of the year to the max date

Hello ,

I have a field month with numbers(1,2,3,4.. ) I mean ,1st is January, 2nd is February etc

When I write Month={'>=1 <=3'} in the set analysis, it shows me the results from January to March. How can I write the range if I want to start from January and to have the results before the max(date) information.

1 Solution

Accepted Solutions
MVP

Try this

Sum({<Month = {"\$(='>=1<=' & Num(Month(Max({1}Date))))"}, Year>} Measure)

26 Replies
Partner

just a quick guest but something like this? month={">=\$(=num#(month(yearstart(now()))))<=\$(=num#(month(now())))"}

Specialist II

You may want to consider using  date oriented flags if this type of calculation is important (and obnoxious).  Generally, such flags reside on a Master Calendar, but even if they are on your Fact and Detail tables, they can provide great value.

Contributor III
Author

It doesn't work

I have data until the February 1 2018. I want to show the values from the 1st January to the February 1. I also compare other years using this formula ------- sum({\$ <Year,Month={'>=1 <= 3'}>})>} Sales) -- this calculates me January February and March Sum in all of the years. I want to change it such way  that it would show me the values until February 1

Partner

do you have a master calendar table?

MVP

May be this

Month = {"\$(='>=1<=' & Num(Month(Max(Date))))"}

Creator III

just clarify me ,you want to compare the values from jan to feb only in all years ?

Contributor III
Author

Yes

Contributor III
Author

Yes

Partner

so should you use this in your set analysis expression:

Your_date_field = {"<=\$(=Max(Date))"}