Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How could I sort a pivot table of an specific order????

Hi Guys, How could I sort a pivot table of an specific order, I attached a pic and the app with 2 pivote tables, I need to sort the below table like the one above, I tryed but it has a "+" and this ´sign doesn´t let me to sort like the table above, any idea??

Thank you Guys!!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use sort expression as =MixMatch(Clasificador_Dias_Condicion,'Current','30 Days','60 Days','90 Days','120 Days','+120 Days') instead of ColumnNo() and set sort by ascending.

Celambarasan

Edit: Check the attached app

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use sort expression as =MixMatch(Clasificador_Dias_Condicion,'Current','30 Days','60 Days','90 Days','120 Days','+120 Days') instead of ColumnNo() and set sort by ascending.

Celambarasan

Edit: Check the attached app

Not applicable
Author

Excelent, thank you celambarasan !!!