topic date sorted in QlikView

date sorted

master_student — Tue, 04 Oct 2016 16:32:08 GMT

Hello folks

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

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

Any idea??

sunny_talwar — Tue, 04 Oct 2016 16:34:26 GMT

May be try this:

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

sunny_talwar — Tue, 04 Oct 2016 16:44:11 GMT

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

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

master_student — Tue, 04 Oct 2016 16:49:32 GMT

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

sunny_talwar — Tue, 04 Oct 2016 16:50:46 GMT

You don't want to sort by date?

master_student — Wed, 05 Oct 2016 08:04:54 GMT

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

sunny_talwar — Wed, 05 Oct 2016 10:21:15 GMT

May be try promoting Cas Traites above Statut

master_student — Wed, 05 Oct 2016 10:44:31 GMT

yep, it works thanks a lot Sunny