select top 10 customers

[marikabi]

Hello,

I'm trying to create a button on Qlik View in order to select the top 10 customers.

Let' say that I have a field "Customer" and values can be: A, B, C, D ...

every week, I receive a report containing the "Revenues" for each of those customers.

I want to sum the revenues (all periods together) for each customer, and using a button select the top 10.

I don't want to use "Select in field" where field is "Revenues" because I really want to make the selection on the Customers, not on values.

Hope it's clear

Thank you

[Gysbert_Wassenaar · Accepted solution]

Try a Select in Field action for the Customers field with ='=rank(sum(Revenues))<=10' as search string