Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 !!!