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: 
Not applicable

Issue in list box for years

Hi maxgro , swuehl,

Can someone please tell me the expression for excluding past three years from the list box dynamically.

4 Replies
sunny_talwar

Exclude past three years or include them?

sunny_talwar

Exclude may be this:

If(not Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

Include:

If(Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

ramoncova06
Specialist III
Specialist III

this is to only show the last three years

aggr(only({<Year = {">=$(max(Year,3))"}>}Year),Year)

this is to exclude the last three year

aggr(only({<Year = {"<=$(max(Year,3))"}>}Year),Year)

antoniotiman
Master III
Master III

Hi,

Try

=Aggr(DISTINCT  If(Rank(TOTAL -YEAR) > 3,YEAR),YEAR)

Regards