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: 
vivek_kalekar
Partner - Contributor II
Partner - Contributor II

How to Sort Second Dimension in Pivot Table of Qlik Sense

I am having a Pivot table which has two Dimensions Namely CustomerID and ProductName and one Measure as Count(OrderID). Now when is sort these dimensions based of on count of Order ID(I am using expression option to sort these dimensions & expression is Count(OrderID) ) ,I am able to sort the First Dimension i.e. Customer ID but when I expand this Dimension to see ProductName ,values don't appear to be sorted.

Can anyone suggest me how to achieve this.?

Thanks in advance.

-VIVEK

Dim1.PNGDim2.PNG

See In above screenshot, In First screen I am able to sort CustomerID based on count of orders but when I Expand customerID 1, Product names don't appear to be sorted according to orders.

2 Replies
MK_QSL
MVP
MVP

In pivot table, you have to sort table

first by first dimension

second by second dimension and

so on...

so when you are not expanding customer ID, the sorting looks OK

now when you are expanding CustomerID, the sorting is still OK.. but now every sub item of Customer ID is sorted by COUNT(OrderID).

so it's looks OK to me.

Update : Sort 2nd Dimension by Expression

COUNT(OrderID)

girirajsinh
Creator III
Creator III

sort second dimension (PROD NAME) too with expression count(ORDID)