Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top three name who have highest sal

=Concat(if(Aggr(rank(sum(SAL)),ENAME>=3),ENAME,','))

not working

1 Reply
Gysbert_Wassenaar

The highest sales will have rank 1, the second highest gets rank 2. So instead of >= you need <=.

=Concat(if(aggr(rank(sum(SAL)),ENAME)<=3, ENAME),', ')

Or perhaps better like this:

=Concat({<ENAME={'=rank(sum(SAL))<=3'}>}ENAME,', ')


talk is cheap, supply exceeds demand