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

[qlikuserkv]

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. 

Thank you,  in advance

[hoangvvo]

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

[JustinDallas]

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.

[qlikuserkv]

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

[agigliotti]

do you have a master calendar table?

[sunny_talwar]

May be this

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

[chinnuchinni]

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

[qlikuserkv]

Yes

[qlikuserkv]

Yes

[agigliotti]

so should you use this in your set analysis expression:

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