Order By multiple dimensions

Simon_BI — Tue, 31 Dec 2019 05:14:55 GMT

Hi Friends,

I have input data like below.

And i wish to have the desired output to load the data order by product and meanwhile the product with Exception "Y" is loaded firstly. The desired output can be found as below.

Attached QVW file you can use to work with. Appreciate if someone can help me here ?

Input data:

Product, DC_NO, STO_NO, DC_QTY, STO Needs, Exception
00169560, DCGACN, 001, 200, 8, N
30234229, DCGAPAU, 003, 20, 10, N
30234229, DCGAPAU, 004, 20, 10, N
00169560, DCGACN, 002, 200, 8, N
00169560, DCGACN, 020, 200, 8, N
00169560, DCGACN, 021, 200, 16, N
00169560, DCGACN, 022, 200, 16, Y
60185269, DCGACN, 028, 20, 24, N
00169560, DCGACN, 023, 200, 8, N
00169560, DCGACN, 024, 200, 8, Y
00169560, DCGACN, 025, 200, 8, N
00169560, DCGACN, 026, 200, 8, N
30234229, DCGAPAU, 005, 20, 10, N
00169560, DCGACN, 027, 200, 16, N
00169560, DCGACN, 028, 200, 24, N
30234229, DCGAPAU, 001, 20, 10, N
30234229, DCGAPAU, 002, 20, 10, N
30234229, DCGAPAU, 007, 20, 10, N
30234229, DCGAPAU, 008, 20, 10, Y
30234229, DCGAPAU, 010, 20, 10, Y
60185269, DCGACN, 027, 20, 16, Y
30234229, DCGAPAU, 006, 20, 10, N
30234229, DCGAPAU, 009, 20, 10, Y

Output:

00169560	DCGACN	022	200	16	Y
00169560	DCGACN	024	200	8	Y
00169560	DCGACN	001	200	8	N
00169560	DCGACN	002	200	8	N
00169560	DCGACN	020	200	8	N
00169560	DCGACN	021	200	16	N
00169560	DCGACN	023	200	8	N
00169560	DCGACN	025	200	8	N
00169560	DCGACN	026	200	8	N
00169560	DCGACN	027	200	16	N
00169560	DCGACN	028	200	24	N
30234229	DCGAPAU	009	20	10	Y
30234229	DCGAPAU	008	20	10	Y
30234229	DCGAPAU	010	20	10	Y
30234229	DCGAPAU	007	20	10	N
30234229	DCGAPAU	001	20	10	N
30234229	DCGAPAU	002	20	10	N
30234229	DCGAPAU	003	20	10	N
30234229	DCGAPAU	004	20	10	N
30234229	DCGAPAU	005	20	10	N
30234229	DCGAPAU	006	20	10	N
60185269	DCGACN	027	20	16	Y
60185269	DCGACN	028	20	24	N

Re: Order By multiple dimensions

tresB — Tue, 31 Dec 2019 06:21:16 GMT

Try like:

Order By Product asc, Exception desc, STO_NO asc;

Re: Order By multiple dimensions

Simon_BI — Tue, 31 Dec 2019 06:35:39 GMT

Hi Tresesco,

I tried your solution in the attached QVW file. But it doesn't work.

The output is not as i expect.

Re: Order By multiple dimensions

tresB — Tue, 31 Dec 2019 07:26:18 GMT

Hi Simon,

If you want to see the actual data in which order it was loaded, you can go to the data model and preview the data or in table box, you have to sort it properly i.e. by 'Load Order' .

Re: Order By multiple dimensions

Simon_BI — Tue, 31 Dec 2019 07:50:41 GMT

Hi Treseco,

Yes, you are right. The back end table is in correct sequence and by sorting properly i get what i want now.

Thanks for your help.

topic Re: Order By multiple dimensions in QlikView

Order By multiple dimensions

Re: Order By multiple dimensions

Re: Order By multiple dimensions

Re: Order By multiple dimensions

Re: Order By multiple dimensions