Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
franklima1950
Contributor II
Contributor II

Ordenação datas

Bom dia,

 Tenho esse campo abaixo:

=(Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM'))

Porém na ordenação da listagem fica errada conforme imagem

franklima1950_0-1645546282692.png

 

É possível classificar pra ficar sequenciado conforme calendário?

Labels (3)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

The field values are text, and the list is alphabetically sorted, which is correct. 

If you want to sort it numerically, you need to create the field values as duals, e.g.

=Dual(
   (Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM')),
   Floor(WeekStart(VENCIMENTO))
   )

View solution in original post

2 Replies
hic
Former Employee
Former Employee

The field values are text, and the list is alphabetically sorted, which is correct. 

If you want to sort it numerically, you need to create the field values as duals, e.g.

=Dual(
   (Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM')),
   Floor(WeekStart(VENCIMENTO))
   )

franklima1950
Contributor II
Contributor II
Author

It worked out! Thank you very much