Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

date sorted

Hello folks

Here I am again the date of my graph is not sorted,  see bellow :

Capture.PNG

my expression : =DAY(date(Floor([Date Dern. modif.]), 'DD')) &  Month(date(Floor([Date Dern. modif.]), 'DD-MM'))


Any idea??

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

=Date(Floor([Date Dern. modif.]), 'DD-MM')

View solution in original post

7 Replies
sunny_talwar

May be try this:

=Date(Floor([Date Dern. modif.]), 'DD-MM')

sunny_talwar

My bad, it seems that you might be looking for this instead:

=Date(Floor([Date Dern. modif.]), 'DDMMM')

master_student
Creator III
Creator III
Author

Thanks, I have a problem in sorting the measure of that table :

Capture.PNG

Capture.PNG

sunny_talwar

You don't want to sort by date?

master_student
Creator III
Creator III
Author

I have the same pb with another table and I need to sort the measures

sunny_talwar

May be try promoting Cas Traites above Statut

Capture.PNG

master_student
Creator III
Creator III
Author

yep, it works thanks a lot Sunny