Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting dimensions in pivot table

Hi guys,

I have a pivot table with the following fields:

fieldnames between brackets []

Rows: Months [Month], Customer as [Bill-to-Customer]

Column: Category [Product Category]

Measure: Sales, which is sum({<Year={'2017'}>}[Nett Amount new EUR])

I do have the top 10 customers per category per month, but now I want to sort these customers based on the sales (descending).

So, the end result should be a pivot where the top 10 customers are shown per category and per month, sorted with the biggest customer on top.

How should I make this sortation in the set analysis?

Mike

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I found the solution plus an example .qvf file in the comment of luismadriz‌ in this discussion Pivot Table Sorting - Qlik sense

Thanks Luis!

View solution in original post

3 Replies
VishalWaghole
Specialist II
Specialist II

Reger below document.

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

Hope this will be helpful for you.

Thanks,

Vishal

Anonymous
Not applicable
Author

First of all, thanks for your reply vishalwaghole‌!

I love the idea, but I can't get it working in Qlik Sense.

Should this only be possible in View or also in Sense?

Anonymous
Not applicable
Author

I found the solution plus an example .qvf file in the comment of luismadriz‌ in this discussion Pivot Table Sorting - Qlik sense

Thanks Luis!