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

Sum Rank filter

Hello,

I developed this formula where I can sum TOP 20:

Sum({<id={"=Aggr(Rank(Sum( sales)), id)<=20"}>} Total sales)

After that, I would like to extract how many IDs have a condition, for example: ID's status = 'YES'.  And the result is 7 for 20.

Thank you very much,

Roberto.

 

Labels (4)
1 Solution

Accepted Solutions
Bunim
Contributor III
Contributor III

Count(distinct {<id={"=Aggr(Rank(Sum( sales)), id)<=20"},status ={"YES"}>} id)

View solution in original post

1 Reply
Bunim
Contributor III
Contributor III

Count(distinct {<id={"=Aggr(Rank(Sum( sales)), id)<=20"},status ={"YES"}>} id)