Skip to main content
Announcements
Announcing Qlik Talend® Cloud and Qlik Answers™ to accelerate AI adoption! 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