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

[#1]

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

[Anonymous]

Try sorting the dimension by expression as shown in the image below;

[#3]

Hi,

This is not solving the issue.Both those fields are calculated fields and does not display automatically in the 'Sorting column' as you showed above.

Thanks

[Anonymous]

HI, I'm assuming the there's a dimension used on the pivot table, sorting the dimension by the measure's expression should change the sort order.

Hope this helps clarify?