topic Re: Top 10 in QlikView https://community.qlik.com/t5/QlikView/Top-10/m-p/1176857#M889502 <HTML><HEAD></HEAD><BODY><P>I have created and additional invoice total and put that as the first expression and then hidden it</P></BODY></HTML> Fri, 26 Aug 2016 09:58:31 GMT 2016-08-26T09:58:31Z Top 10 https://community.qlik.com/t5/QlikView/Top-10/m-p/1176853#M889495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list of Customer, Target and Invoice Total</P><P></P><P>I want to display the top 10 customers by invoice Total and I have used the dimension limits and this has grouped as I want all the top 10 customers and an other section. However, to do this correctly Invoice has be listed first in the expression.</P><P></P><P>Is there a way round this</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-10/m-p/1176853#M889495 2020-11-25T16:16:04Z Re: Top 10 https://community.qlik.com/t5/QlikView/Top-10/m-p/1176854#M889497 <HTML><HEAD></HEAD><BODY><P>You can use Rank function with Aggregate function, but that can effect performance</P></BODY></HTML> Fri, 26 Aug 2016 09:44:57 GMT https://community.qlik.com/t5/QlikView/Top-10/m-p/1176854#M889497 sunny_talwar 2016-08-26T09:44:57Z Re: Top 10 https://community.qlik.com/t5/QlikView/Top-10/m-p/1176855#M889499 <HTML><HEAD></HEAD><BODY><P>will this allow me to have a group of others though. </P></BODY></HTML> Fri, 26 Aug 2016 09:49:22 GMT https://community.qlik.com/t5/QlikView/Top-10/m-p/1176855#M889499 2016-08-26T09:49:22Z Re: Top 10 https://community.qlik.com/t5/QlikView/Top-10/m-p/1176856#M889501 <HTML><HEAD></HEAD><BODY><P>Do you have a particular example, I am not really sure I understand what you mean when you say group of others?</P><P></P><P>UPDATE: I see what you mean, I believe you can still create that with little manipulation <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 26 Aug 2016 09:50:44 GMT https://community.qlik.com/t5/QlikView/Top-10/m-p/1176856#M889501 sunny_talwar 2016-08-26T09:50:44Z Re: Top 10 https://community.qlik.com/t5/QlikView/Top-10/m-p/1176857#M889502 <HTML><HEAD></HEAD><BODY><P>I have created and additional invoice total and put that as the first expression and then hidden it</P></BODY></HTML> Fri, 26 Aug 2016 09:58:31 GMT https://community.qlik.com/t5/QlikView/Top-10/m-p/1176857#M889502 2016-08-26T09:58:31Z