Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

See why BI users voted Qlik #1 in 11 categories. GET REPORT
Showing results for 
Search instead for 
Did you mean: 

PivotTable Sorting

I want to sort my pivottable so that all employees from a cost center are grouped together. 


In the image below, there are gaps between the employees for CC 2138 - Final Assembly because of the Employee Name field sort. I've tried overriding the Employee Name sort by using the sort by expression feature. I've put the cost center field there, the employee name, i've tried aggregating a measure by cost center or employee name. Nothing has worked so far.


pivottable sort.JPG

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” — Antoine de Saint-Exupéry
1 Reply

i think doing something like in the scrip:


autonumber(Cost Center) as SortField

and use "SortField" for sorting.