topic Re: Non-sequential alphabetic sort in QlikView

Non-sequential alphabetic sort

Tue, 07 May 2013 15:31:16 GMT

Hi all,

I have some data as below sorted by date and Doc type:

Date Doc type Doc No

----------------- ------------- -------------

1/1/11 DN (delivery note) 10

1/1/11 GRN (Goods received Note) 14

I want to sort first by date in ascending order (it's ok and normal) and then Doc Type GRN first and then DN to have a natural flow.

BR,

SAK

Re: Non-sequential alphabetic sort

Gysbert_Wassenaar — Tue, 07 May 2013 15:45:52 GMT

Open the properties window of the chart object where you add the fields, select the Sort tab. Then move Date to the top position and set the Sort By option to Numeric Value - ascending. Move Doc type to the second position and set the Sort By option to Text - descending.

Re: Non-sequential alphabetic sort

Tue, 07 May 2013 16:06:16 GMT

Problem is there are more than two types of Doc Types, one starting from D, one G and one I. Then sorting in descending order does not help. I want GRN (G) on top and then D (Delivery Note) and ISS (Issues).

Re: Non-sequential alphabetic sort

Gysbert_Wassenaar — Tue, 07 May 2013 16:15:08 GMT

In that case create an inline table where you fix the order

OrderedType:

Load * inline [

Doc type

GRN

ISS ];

// other load stuff here.

Now the inline table will define the sort order you get when you use the Sort By option Load Order