Qlik Community

Qlik Sense App Development

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

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
benwspx1
New Contributor III

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

Re: PivotTable Sorting

i think doing something like in the scrip:

 

autonumber(Cost Center) as SortField

and use "SortField" for sorting.

 

regards