Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

last 3 year in list box

Hi All,

I want to show only last three years in list box.

e.g.

2015-2016

2014-2015

2013-2014

Thanks

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

Tyr like:

=Aggr(If(Rank(SubField(Year,'-',1))<=3, Year),Year)

PFA

View solution in original post

1 Reply
tresB
Champion III
Champion III

Tyr like:

=Aggr(If(Rank(SubField(Year,'-',1))<=3, Year),Year)

PFA