Qlik Community

Qlik Sense App Development

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

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

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

1 Reply
Partner
Partner

i think doing something like in the scrip:

 

autonumber(Cost Center) as SortField

and use "SortField" for sorting.

 

regards