Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ramanarayan
		
			ramanarayan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		One list box expression could be like:
=Aggr(If(Rank(SubField(Qtr, '-',2)&SubField(Qtr, '-',1))<4, Qtr), Qtr)
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		One list box expression could be like:
=Aggr(If(Rank(SubField(Qtr, '-',2)&SubField(Qtr, '-',1))<4, Qtr), Qtr)
 ramanarayan
		
			ramanarayan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		