3 Replies Latest reply: Aug 9, 2017 2:38 PM by Ugonna Okoli RSS

    Sorting in Descending the Highest Change in Amount in QlikSense Pivot Tables

    Mithun Phadnis

      Hi All,


      I need to find out the biggest changers over the last two months.I need these to be sorted with the highest change and its name being displayed first using Pivot Tables.

      I have created a pivot table and also added two columns with one being Difference in amounts and other being percent change. I am unable to sort these based on the highest percent change.


      Please find the attached screenshot of two columns that have been calculated based on amounts. I want the result to have the highest change as first column



      I am using QLIKSENSE and not Qlikview. Kindly paste the code here as I have problem opening .qvf files.