2 Replies Latest reply: May 26, 2015 5:35 PM by Ping Huang RSS

    Is it possible to sort measure in pivot table using Qlik Sense?

      Using Qlik Sense, would it be possible to sort the data in a pivot table?

      such as sorting the Sales column in the pivot table on the help page:

      https://help.qlik.com/sense/en-us/online/Subsystems/Hub/Content/Visualizations/PivotTable/PivotTable.htm

       

      Thanks,

      Ping

        • Re: Is it possible to sort measure in pivot table using Qlik Sense?
          Gysbert Wassenaar

          Yes, that's possible. It depends on your data what kind of trickery you need to resort to. It might be enough to set the sorting of each dimension to Custom, enable the Sort by expression option and use sum(Sales) as expression. That works for data sets like

           

          Dim1Dim2Dim 3Sales
          ARX100
          ASY200
          ASZ300
          BKF50
          BKG75
          BLH100
          CMQ125

           

          But if you have something like

           

          Dim1Dim2Dim 3Sales
          ARX550
          ASY200
          ASZ300
          BRX50
          BSG75
          BSZ100
          CMZ125

           

          then you probably have to resort to calculated dimensions like dual(Dim2, aggr(sum(Sales),Dim1,Dim2) for Dim2. Then you can sort that calculated dimension with Sort Numerically.

           

          Unfortunately the pivot table has no Sort by Y-value like previous versions of Qlikview had.

          • Re: Is it possible to sort measure in pivot table using Qlik Sense?

            Thank you Gysbert.

            How did you make the headers click-able to sort? I see they are clickable in your tables but the headers are not clickable in the pivot table created using Qlik Sense Pivot table visualization.