Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AleCruc94
Contributor III
Contributor III

Set Analysis

Hi, 

I want to know how to incluse a set analysis into the following formula

=Aggr(if(rank(sum(Sales))<=3,Clustomers),Clustomers)

as i want to obtain in a table the top 3 customer for sales but for a specific activiti, so that I need to inclued a prefilter in this formula as {ACTIVITY = 'COP. TASSO'}

 

Thanks in advance

 

1 Reply
Taoufiq_Zarra

if i understood correctly

=Aggr(if(rank(sum({<ACTIVITY={'COP. TASSO'}>}Sales))<=3,Clustomers),Clustomers)

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉