Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

How to customize list box to display latest 3 quarters

Attached is a sample qlikview document. We need to be able to customize the Qtr list box to be able to show the latest 3 quarters. The data will keep appending and at all the time this list box should only show the latest 3 quarters.

 

Thanks,

Ram

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

One list box expression could be like:

=Aggr(If(Rank(SubField(Qtr, '-',2)&SubField(Qtr, '-',1))<4, Qtr), Qtr)

View solution in original post

2 Replies
tresesco
MVP
MVP

One list box expression could be like:

=Aggr(If(Rank(SubField(Qtr, '-',2)&SubField(Qtr, '-',1))<4, Qtr), Qtr)
ramanarayan
Creator
Creator
Author

can this expression be slightly altered to display the selected quarter + 2 previous quarters?