Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
WhatsUp
Contributor II
Contributor II

Sorting based on dimension and measure

Hi guys,

I got the following task:

I work with a pivot table. In the pivottable I have multiple rows like so: Date | Customer_ID | Text

As KPI I use  count(number). I want to order the pivottable by date and afterwards it should order based on the count(number) so that I see the highest number for each date. As far as I tried I could only sort either by date or by the KPI but not both. Could someone help me out?

 

 

 

Labels (1)
2 Replies
justISO
Specialist
Specialist

Hi, try modify sorting properties from Auto to Custom and set 'Date' field sort numerically, and 'Customer' field set to be sorted by expression "count(number)":

justISO_0-1727088794370.png

WhatsUp
Contributor II
Contributor II
Author

Thanks for the reply.

Unfortunately it doesn't work. I have the Date and Customer_ID. On the rows and the count(sales) in the KPI section. When sorting the date like you descriped it works. But the count(sales) isn't sorted.