Suggest an Idea

[JPT]

Currently sorting using 'Sort by first measure' does not work properly when using one dimension on Column and multiple dimensions on Row.

When we enable Show Totals on every dimension and then enable 'Sort by first measure' with every Dimension in Row the Sorting will work properly:

When we then move our Mix dimension to Column dimension, the sorting breaks:

Our client wants to always be able to Sort everything Descending also when using the Column dimension (working with only Row dimensions is not an option).

Also discussed with Qlik Support:

Case Details

02221314 - Sorting in Pivot with Totals and Multiple dimensions

[Marcoimp]

Hello,
there is a fundamental error in your interpretation of the ordering of the columns.
The columns are actually ordered.
You have to add up the whole description "A" of each group (in "Mix", "Continent", "Country" and in "Client").
If you wish and you want to try your hand in Italian (!!), here you will find all the description and a way to allow users to sort the columns in the Pivot;
https://www.qlikclips.it/sort-sulle-pivot-2/

[Meghann_MacDonald]

Hi @JPT , thank you for submitting. The pivot table sorting is working as designed and you are able to further order your columns using the information from @Marcoimp . As I think we could help further with this I suggest resubmitting as a problem in the Qlik Sense App Development Forum where community users can help you get the proper sorting for your customer.

Meghann