Sort straight table (sort by most recent date)

[lessassy]

Hello Everyone,

I have a straight table with a date field in format ("DD-MM-YYYY")

I can't figure out how to sort it

I already try the formula that you can see in the picture, but my table doesn't change.

All the data are in the same table.

Anyone have a solution ?

(I'm not using a master calendar in that case)

Thank you in advance

[niclaz79]

Hi,

Use your sort expression on the dimension 'Priority Px' instead and see how that works.

[lessassy]

It still doesn't work.

Do you have any other solution ?

Or maybe i can attach my qvw below

[sunny_talwar]

Promote Incident Date to the top of the list to sort 1st by the Incident Date

[kumarravi]

Hey,

Go to - >

1. Right click and choose properties

2. Sort

3. Write the expression Date#(Date, "DD-MM-YYYY") by checking the expression section

4. Click the Text section and select Z->A

5. Keep the Date section at TOP (Promote)