Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Month sort order not done in natural way

Hello,

I'd like to sort the month by descending order in a pivot table.  I set the sort option in the properties pane in the manner below, but it is not sorted in the descending order as intended.  I'd appreciate it if anyone can tell me where I am going wrong with this.  

Sakiko_0-1623073569471.png

Thank you for your help.

3 Replies
sergio0592
Specialist III
Specialist III

Hi,

In expression try with : 

Only({1} MONTH)

 

Newbie777
Partner - Creator III
Partner - Creator III
Author

Thanks I tried, but I get the error message like below.  

Newbie7_0-1623226331124.png

But anyway, I solved that issue by an alternative way.  

sergio0592
Specialist III
Specialist III

So, your field is Month not MONTH as in my exemple.