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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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