Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Sorting dimensions in pivot table

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

Thanks Luis!

3 Replies
vishalwaghole
Valued Contributor II

Re: Sorting dimensions in pivot table

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
Contributor II

Re: Sorting dimensions in pivot table

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
Contributor II

Re: Sorting dimensions in pivot table

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

Thanks Luis!

Community Browser