topic Re: Sorting pivot table in App Development

Sorting pivot table

DGO — Sat, 16 Nov 2024 03:19:49 GMT

Will the new version of Qlik Sense Enterprise allow users to sort pivot table dimensions or measures?

Re: Sorting pivot table

TimvB — Sun, 09 Feb 2020 15:10:31 GMT

Yes, users can sort a pivot table by dimension or measure in Qlik Sense Enterprise. Christof Schwarz has a good video tutorial where he explains how this works.

Re: Sorting pivot table

DGO — Sun, 09 Feb 2020 15:33:42 GMT

I’ve watched that video. That’s a workaround that takes up valuable screen real estate. I’m asking for a native Qlik solution. My expectation is for the user to be able to click the pivot column headers to sort ascending or descending.

Re: Sorting pivot table

TimvB — Sun, 09 Feb 2020 15:36:12 GMT

I am afraid this is not possible. The pivot table has multiple dimensions with grouped values, so it does not know by default how to sort.

Re: Sorting pivot table

DGO — Sun, 09 Feb 2020 15:54:32 GMT

It’s not possible now. That’s why I bring up this question for the future release of Qlik Sense. Users intuitively click the column headers to sort, but the UI doesn’t respond. It’s possible and I’m confident Qlik can implement a clean solution.

Re: Sorting pivot table

agigliotti — Wed, 12 Feb 2020 16:56:51 GMT

I really think it would be a useful feature for end users if it's possible to implement.

@Michael_Tarallo What do you think about ?

Best regards
Andrea

Re: Sorting pivot table

agigliotti — Thu, 13 Feb 2020 11:07:04 GMT

Regarding this topic i'd like to share with you the below scenario.

I have a pivot table with 3 dimensions (row) and 1 measure.

First of all , if the dimension value is NULL the related value it's not being sorted and it's always showed on top of the list!

the sorting is the same for all dimensions: by expression (the same as measure) descending

the expected result should be all pivot table levels being sorted in descending order for measure value.

the actual result is the first 2 dimensions are right sorted , while the third one is sorted in unexpected way.

What could be the reason of what's happening ?

Many thanks in advance for your time.

Best regards
Andrea

Re: Sorting pivot table

Michael_Tarallo — Thu, 13 Feb 2020 19:43:45 GMT

Hi Andrea -

I will pass along this feedback. I too would like to be able to sort in the pivot table.

Regards,

Mike

Re: Sorting pivot table

Patric_Nordstrom — Sun, 16 Feb 2020 19:51:13 GMT

Thanks for the feedback,

Note that the straight table and the pivot table are very different:

Straight table
Row-based approach
Not grouped
The rows are sorted, not necessarily the dimensions
Excellent sorting, but limited grouping

Pivot table
Dimension-based approach
Grouped by dimensions
The dimensions are sorted, not the rows
Excellent grouping, but limited sorting

That said, I hope we can get "Sort by Y-value" in Sense during 2020. Sort by Y-value preceeds the dimension sorting with sorting on the first measure under certain circumstances: only row dimensions, no cross tables and subtotal must be on.

Thanks,
Patric