Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
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


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)