Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: How to customize list box to display latest 3 quarters

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
Highlighted
MVP
MVP

Re: How to customize list box to display latest 3 quarters

One list box expression could be like:

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

View solution in original post

Highlighted
Creator
Creator

Re: How to customize list box to display latest 3 quarters

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