topic Re: Indirect Top X Filtering & Custom Grouping/Sorting in QlikView https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300926#M586774 <HTML><HEAD></HEAD><BODY><P>Hi Krishna,</P><P></P><P>The desire result should only return 5 employees + Others. I want the list of Employees that serve the top 10 customer, and <EM>not </EM>the top 10 Employees. Hope this is clearer.</P></BODY></HTML> Mon, 20 Jun 2011 04:58:35 GMT 2011-06-20T04:58:35Z Indirect Top X Filtering & Custom Grouping/Sorting https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300924#M586772 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to create a table that will list the employees that handle the top 10 customers. I somehow manage to create the list using set analysis, but I have an additional requirement. I want to group those employees that are not handling the top 10 customers as "Others". So, the table should show the Employees that server the top 10 customer + "Others". And this "Others" will be at the bottom of the table.</P><P></P><P>I attached a sample QVW with some explanation inside.</P></BODY></HTML> Mon, 20 Jun 2011 03:57:06 GMT https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300924#M586772 2011-06-20T03:57:06Z Re: Indirect Top X Filtering & Custom Grouping/Sorting https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300925#M586773 <HTML><HEAD></HEAD><BODY><P>Modified qvw file showing the changes desired by you is attached.</P><P></P><P>Hope this helps.</P></BODY></HTML> Mon, 20 Jun 2011 04:34:20 GMT https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300925#M586773 nagaiank 2011-06-20T04:34:20Z Re: Indirect Top X Filtering & Custom Grouping/Sorting https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300926#M586774 <HTML><HEAD></HEAD><BODY><P>Hi Krishna,</P><P></P><P>The desire result should only return 5 employees + Others. I want the list of Employees that serve the top 10 customer, and <EM>not </EM>the top 10 Employees. Hope this is clearer.</P></BODY></HTML> Mon, 20 Jun 2011 04:58:35 GMT https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300926#M586774 2011-06-20T04:58:35Z Re: Indirect Top X Filtering & Custom Grouping/Sorting https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300927#M586775 <HTML><HEAD></HEAD><BODY><P>Bump!</P></BODY></HTML> Fri, 24 Jun 2011 00:55:12 GMT https://community.qlik.com/t5/QlikView/Indirect-Top-X-Filtering-Custom-Grouping-Sorting/m-p/300927#M586775 2011-06-24T00:55:12Z