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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom sort doesn't work

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?

25 Replies
alexandros17
Partner - Champion III
Partner - Champion III

This is the workink condition, let me know.

min(Aggr(NODISTINCT min(StartDate), WORKCENTER, ORDER))

Not applicable
Author

Min expression doesn't exist in final chart, I created it just fot testing

antoniotiman
Master III
Master III

In expression Sort ORDER

Aggr(Rank(-Min(StartDate),0,1),ORDER)

Not applicable
Author

unfortunately does not work

alexandros17
Partner - Champion III
Partner - Champion III

I used that expression in your document, the one I attached, please tell me where the error is?

Not applicable
Author

I tried your solution, but here begins distortion

   

issue.jpg

Not applicable
Author

For example here

issue.jpg

agree?

tresesco
MVP
MVP

This?

Not applicable
Author

issue.jpg

the same problem(((

It seems that problem causes orders that have both Working centers

antoniotiman
Master III
Master III

I'm sorry Alex,

in this case, do You want Priority Order or Priority StartDate ?