Custom sort doesn't work

[#1]

Hello everyone!

I have 4 fields Working Center, Order, Order Start Date and Order End Date.

I want to sort my straight table in this order: Working Center A-Z, Order by min(StartDate).

I created custom sort expression , but it doesn't work.

See attachment

What have I done wrong?

[alexandros17]

Try this expression for your order sort

min(Aggr(NODISTINCT StartDate, WorkCenter, Order))

[tresesco]

Promote min (expression label) to second position and sort it in ascending order.

[antoniotiman]

Try to Promote Order in Sort Tab

[#5]

I need the working center to be the first in priority

[tresesco]

Isn't it so in my attached sample? Am I missing something ? What is your expected output?

[#7]

Thank's. I tried your solution, but it doesn't work for more lines. First Workcenter is sorted well, but the second is chaotic

[#8]

Your solution worked on the sample, but in whole list of orders it works incorrect.

See attachment with more data

[qlikmsg4u]

Is this right?

[tresesco]

Like this? You did not promote min to second position !