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.

       

      Thanks,

      Mithun