Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

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

Tags (1)
3 Replies
okolyug16
Contributor II

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

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

Sort by expression.PNG

Not applicable

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

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

okolyug16
Contributor II

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

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?