topic select top 10 customers in QlikView https://community.qlik.com/t5/QlikView/select-top-10-customers/m-p/112320#M763790 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to create a button on Qlik View in order to select the top 10 customers.</P><P>Let' say that I have a field "Customer" and values can be: A, B, C, D ...</P><P>every week, I receive a report containing the "Revenues" for each of those customers.</P><P>I want to sum the revenues (all periods together) for each customer, and using a button select the top 10.</P><P>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.</P><P></P><P>Hope it's clear <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thank you </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT marikabi 2020-11-25T16:16:04Z select top 10 customers https://community.qlik.com/t5/QlikView/select-top-10-customers/m-p/112320#M763790 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to create a button on Qlik View in order to select the top 10 customers.</P><P>Let' say that I have a field "Customer" and values can be: A, B, C, D ...</P><P>every week, I receive a report containing the "Revenues" for each of those customers.</P><P>I want to sum the revenues (all periods together) for each customer, and using a button select the top 10.</P><P>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.</P><P></P><P>Hope it's clear <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thank you </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/select-top-10-customers/m-p/112320#M763790 marikabi 2020-11-25T16:16:04Z Re: select top 10 customers https://community.qlik.com/t5/QlikView/select-top-10-customers/m-p/112321#M763791 <HTML><HEAD></HEAD><BODY><P>Try a Select in Field action for the Customers field with ='=rank(sum(Revenues))&lt;=10' as search string</P></BODY></HTML> Fri, 20 Jul 2018 16:22:56 GMT https://community.qlik.com/t5/QlikView/select-top-10-customers/m-p/112321#M763791 Gysbert_Wassenaar 2018-07-20T16:22:56Z