Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting of a pivot table (different sorting if two dimensions)

I have a pivot table with two dimensions and two formulas:

First dimension: Item Category

Second dimension: Customer

First formula: Sum(Sales)

Second formula: Sum(Quantity)

The sorting of the first dimension should be by loading order (or alphabetical).

The sorting of the second dimension should be by the first formula.

What I tried:

1) "Sort by y-Value": Sorts both dimensions by Sum(Sales) => Not what I want.

2) "Sort by Expression" for the second dimension: "Sum(Sales)" => Sorts the customers depending on there total Sales disregarding the first dimension => Again not what I want.

Question: Is there a way to tell QV that the "sort by expression" should consider the first dimension? Or is that what I want just something QV can't handle?

Thanks in advance and regards

Alex

3 Replies
nagaiank
Specialist III
Specialist III

An example with different sort order for the two dimensions ia attached. Is this what you want to do?

Not applicable
Author

Your example describes the problem but unfortunalety not the solution

Example.jpg

Customer B has the highest Sales overall (900 + 700 = 1600). That's why he is in first place for both Categories.

What I want is the following:

1 - A - 1100

1 - B - 900

1 - C - 750

2 - B - 700

2 - C - 500

2 - A - 400

the customers should be sorted by sales for each category different.

nagaiank
Specialist III
Specialist III

According to QlikView Reference manual, 'Pivot tables can only be sorted by some property of the first column.'