Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

How to sort the data?

Hi all,

I am using pivot in Qlik sense. I have sales figures for different locations for last six months. Now I want to sort the locations in descending order based on sales of latest month. Can some one help me on how to do this?

1 Reply
Honored Contributor II

Re: How to sort the data?


attach is an example app

basically you need to go to the dimension you want to sort

and in the dimension select sort by expression

and use expression similar to this

=Sum({<displayMonth, Month={"$(=max(Month))"}>}Sales)