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.

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

!hi

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)