Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to show top 5 customers contribution in funds

Hello everyone,

I want to show only top 5 customers having contributed in Each Fund, Can some one please help me out i didn't find any good help.

Output

FUND NO TOP 5 CUSTOMERS CONTRIBUTION IN AMOUNT 
13010001 =   (SUM AMOUNT OF TOP 5 CUSTOMERS) / (TOTAL                AMOUNT )
13010002  
13010003  
13010004  
13010005  
13010006  
13010007  
13010008  
13010009  
13010010  
13010011  
13010012  
13010013  

 

Labels (6)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Try:

= Sum({<[CUSTOMER NO]={"=Rank(Sum(AMOUNT)) <=5"} >}AMOUNT)
    /
   Sum(TOTAL AMOUNT)

View solution in original post

1 Reply
BrunPierre
Partner - Master
Partner - Master

Try:

= Sum({<[CUSTOMER NO]={"=Rank(Sum(AMOUNT)) <=5"} >}AMOUNT)
    /
   Sum(TOTAL AMOUNT)