topic Custom Sort in QlikView https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289742#M587321 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I sort my straight table like the one in the attached excel (customsort.xls)? The customer must be sort based on the amount, but I only want the Top 3 Customer to be displayed. Other customers that not in the Top 3 will be grouped into "Others". This "Others" group must always be at the last row in the table.</P><P></P><P>I also attached Test.qvw and Test.xlsx that I'm currently working on.</P></BODY></HTML> Wed, 15 Jun 2011 10:04:55 GMT 2011-06-15T10:04:55Z Custom Sort https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289742#M587321 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I sort my straight table like the one in the attached excel (customsort.xls)? The customer must be sort based on the amount, but I only want the Top 3 Customer to be displayed. Other customers that not in the Top 3 will be grouped into "Others". This "Others" group must always be at the last row in the table.</P><P></P><P>I also attached Test.qvw and Test.xlsx that I'm currently working on.</P></BODY></HTML> Wed, 15 Jun 2011 10:04:55 GMT https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289742#M587321 2011-06-15T10:04:55Z Re: Custom Sort https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289743#M587322 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please look at the attached file, I hope that helps.</P><P></P><P>Greetings from Munich</P></BODY></HTML> Wed, 15 Jun 2011 11:48:17 GMT https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289743#M587322 brenner_martina 2011-06-15T11:48:17Z Re: Custom Sort https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289744#M587323 <HTML><HEAD></HEAD><BODY><P>Wow, thanks! Didn't know that there is such option!</P></BODY></HTML> Thu, 16 Jun 2011 02:26:08 GMT https://community.qlik.com/t5/QlikView/Custom-Sort/m-p/289744#M587323 2011-06-16T02:26:08Z