topic Sort straight table (sort by most recent date) in QlikView

Sort straight table (sort by most recent date)

lessassy — Mon, 02 Jul 2018 11:43:01 GMT

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 — Mon, 02 Jul 2018 12:04:38 GMT

Hi,

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

lessassy — Tue, 10 Jul 2018 13:05:32 GMT

It still doesn't work.

Do you have any other solution ?

Or maybe i can attach my qvw below

sunny_talwar — Tue, 10 Jul 2018 13:10:35 GMT

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

kumarravi — Tue, 22 Mar 2022 18:26:52 GMT

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)