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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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 !!!