Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
qlikuserkv
Contributor III
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. 

Thank you,  in advance

1 Solution

Accepted Solutions
sunny_talwar

Try this

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

View solution in original post

26 Replies
hoangvvo
Partner
Partner

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

JustinDallas
Specialist II
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.

qlikuserkv
Contributor III
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

agigliotti
Partner
Partner

do you have a master calendar table?

sunny_talwar

May be this

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

chinnuchinni
Creator III
Creator III

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

qlikuserkv
Contributor III
Contributor III
Author

Yes

qlikuserkv
Contributor III
Contributor III
Author

Yes

agigliotti
Partner
Partner

so should you use this in your set analysis expression:

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