Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom Sort

Hi all,

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.

I also attached Test.qvw and Test.xlsx that I'm currently working on.

1 Solution

Accepted Solutions
Partner
Partner

Hi,

please look at the attached file, I hope that helps.

Greetings from Munich

View solution in original post

2 Replies
Partner
Partner

Hi,

please look at the attached file, I hope that helps.

Greetings from Munich

View solution in original post

Not applicable

Wow, thanks! Didn't know that there is such option!