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

[qlikuserkv]

All years but only these months ( from January to max month)

[sunny_talwar]

This same expression should work... isn't it working? or what is the issue that you are seeing?

[qlikuserkv]

When my dimension is month,  this formula only shows me current year's month from January to max month information. I want to show all years in these months together --- January(2014,2015,2016,2017,2018) , February(2014,2015,2016,2017,2018), March (2014,2015,2016,2017,2018), April(2014,2015,2016,2017,2018)....

[sunny_talwar]

Are you sure you are using this expression

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

and not this?

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

If you are using the second expression.... it will not work because you are telling your expression to look at the Max(Year).

[qlikuserkv]

I understand and I use the first formula.

It shows me only this

And I want something like this

[sunny_talwar]

Have you added Year as your second dimension?

[qlikuserkv]

I just added this, I deleted {1} from the function and it works. Now I should change the colors of these years. Thanks again!!