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
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Contributor III
Contributor III

Sorting Pivot Table by Year

Hi!

I have a problem with sorting in pivot table (Qlik Sense). In the attachment I show what I mean.

I would like the expression to be sorted in descending order for each year. Is it possible?

4 Replies
Ricardo_Gerhard
Employee
Employee

Dear Kuba,

You can sort by expression like this sample.

Changing the sorting of a visualization using expressions - Qlik Sense - YouTube

Regards,

Ricardo Gerhard

Ricardo Gerhard
OEM Solution Architect
LATAM
qlikeers
Contributor III
Contributor III

Thanks for Your answer.

But, unfortunately, in my case it didn't work.

For e.x.:

=if(Rank(sum([Sales]))=1,1,

    if(Rank(sum([Sales]))=2,2,3))

It works for first year in pivot table. Subsequent years are sorted according to the order of the first year (regardless of value).

rajeshqvd
Creator II
Creator II

Sort by Year descending order

qlikeers
Contributor III
Contributor III

I tried probably all available default sorting options (and few expressions). I could not sort every year (1 dim) in a pivot table separately.


You can try to do this exercise in Qlik Sense (Years and Product in dimmensions, sum (sales) in measures).