4 Replies Latest reply: Jan 26, 2017 5:20 PM by Kanishk Chadha RSS

    Sorting within a Pivot Table with multiple dimensions and multiple measures

    Kanishk Chadha

      Hi,

       

      I am building a chart in Qlik Sense 3.1 that contains a pivot table with multiple dimensions as rows and multiple measures as columns. Currently the values of each dimension are sorted alphabetically. Instead, I would like the pivot table's dimensions to be sorted in descending order based off a specific measure.

       

      I have tried adding the measure's expression in the "Sort by Expression" for each dimension, however this has not worked.

       

      If you have any solutions please let me know.

       

      Thanks