Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mslottje
Creator II
Creator II

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
mslottje
Creator II
Creator II

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

mslottje
Creator II
Creator II

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?

mslottje
Creator II
Creator II

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