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: 
rittermd
Master
Master

Limit Dimensions to Last 5 Years

I am trying to limit the bars in my chart to only show the last 5 years.

I have coded this set analysis.  But something is off and not working and I am just not seeing it.

Count({$<[Hire_Date_Most_Recent.autoCalendar.Year]={">=$(=vCurrentYear-5)"}>}EmployeeID)

vCurrentYear = 2017

I got this set analysis to work.  But it is not what I ultimately want.

Count({$<[Hire_Date_Most_Recent.autoCalendar.Year] = {">=$(=date(today()-2100))"} >} Employee_ID)

21 Replies
Anonymous
Not applicable

ok, I'll try it again , let's stopp here I don't want to take over this thread ...

sunny_talwar

Before we do, this link might help OP

Qlik Sense 2.2 automatic date handling - set analysis