Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting in Pivot

We have a self-service BI pivot table where the user selects any dimension/Dimensions and measures.

The requirement  is to Sort the table based on measure-  Sales when various dimensions are selected

For example – we have Dim- A,B,C,D,E,F.  Some of these dimensions are part of hierarchy (Product line , Product Code etc) while others are not.

We have defined sort order in Table Properties > Sort as B,D,F,A,E and for all these dim we have set in the expression tab as sum(Sales).

The sorting works fine when the user selects only one dimension .

But the sorting does not work when dimensions from different hierarchy are selected.

Is there any other way where this sorting can be achieved?

Thank you in Advance

2 Replies
bindu_apte
Creator III

Pivot is not feasible on sorting.

Use Straight table that will help you out on sorting.

Hope this will be helpful.

vikasmahajan

Hi

Refer this https://community.qlik.com/docs/DOC-7220 , You can not sort in pivot table as you want.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.