Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Indirect Top X Filtering & Custom Grouping/Sorting

Hi all,

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.

I attached a sample QVW with some explanation inside.

3 Replies
nagaiank
Valued Contributor III

Re: Indirect Top X Filtering & Custom Grouping/Sorting

Modified qvw file showing the changes desired by you is attached.

Hope this helps.

Not applicable

Re: Indirect Top X Filtering & Custom Grouping/Sorting

Hi Krishna,

The desire result should only return 5 employees + Others. I want the list of Employees that serve the top 10 customer, and not the top 10 Employees. Hope this is clearer.

Not applicable

Re: Indirect Top X Filtering & Custom Grouping/Sorting

Bump!

Community Browser