Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator II
Creator II

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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).