topic Re: Custom sort doesn't work in QlikView

Custom sort doesn't work

Thu, 16 Jul 2015 08:47:47 GMT

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?

Re: Custom sort doesn't work

alexandros17 — Thu, 16 Jul 2015 08:52:40 GMT

Try this expression for your order sort

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

Re: Custom sort doesn't work

tresB — Thu, 16 Jul 2015 09:02:37 GMT

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

Re: Custom sort doesn't work

antoniotiman — Thu, 16 Jul 2015 09:03:26 GMT

Try to Promote Order in Sort Tab

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:07:43 GMT

I need the working center to be the first in priority

Re: Custom sort doesn't work

tresB — Thu, 16 Jul 2015 09:11:38 GMT

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

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:13:22 GMT

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

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:16:45 GMT

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

See attachment with more data

Re: Custom sort doesn't work

qlikmsg4u — Thu, 16 Jul 2015 09:20:01 GMT

Is this right?

Re: Custom sort doesn't work

tresB — Thu, 16 Jul 2015 09:20:44 GMT

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

Re: Custom sort doesn't work

alexandros17 — Thu, 16 Jul 2015 09:23:41 GMT

This is the workink condition, let me know.

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

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:30:00 GMT

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

Re: Custom sort doesn't work

antoniotiman — Thu, 16 Jul 2015 09:30:28 GMT

In expression Sort ORDER

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

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:35:50 GMT

unfortunately does not work

Re: Custom sort doesn't work

alexandros17 — Thu, 16 Jul 2015 09:42:55 GMT

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

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:44:10 GMT

I tried your solution, but here begins distortion

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:45:48 GMT

For example here

agree?

Re: Custom sort doesn't work

tresB — Thu, 16 Jul 2015 09:46:29 GMT

This?

Re: Custom sort doesn't work

Thu, 16 Jul 2015 09:49:38 GMT

the same problem(((

It seems that problem causes orders that have both Working centers

Re: Custom sort doesn't work

antoniotiman — Thu, 16 Jul 2015 10:08:06 GMT

I'm sorry Alex,

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