topic Sorting in QlikView

Sorting

Mon, 12 Mar 2012 02:02:40 GMT

Can i sort a particular column of the loaded table in .qvw fle in particular order for example say asc or desc??????

Re: Sorting

CELAMBARASAN — Mon, 12 Mar 2012 04:33:00 GMT

Hi,

Did you tried with Order by Fieldname asc?

Load

Resident Table Order By FieldName asc;

expecting something other than this?

Celambarasan

Sorting

jagan — Tue, 13 Mar 2012 06:35:12 GMT

Hi,

You can order the data in a Field by using Order By clause. Ascending (ASC) is default and if you want to sort by descending order then you explicitly specify DESC.

For Ascending

TableName:

Load

Resident Table

Order By FieldName ASC;

For Descending

TableName:

Load

Resident Table

Order By FieldName DESC;

Regards,

Jagan.

Sorting

kamalqlik — Tue, 13 Mar 2012 07:45:59 GMT

Hi Manish ,in qlikview thiss can be done by order by.

For example we are having a customer table

Customer:

Load Address,

Phone no,

CustomerID,

etc

from Customer.qvd

CustomerFinal:

load *

resident Customer

Order By CustomerID ASC;

By default qlikview uses ASC

in the same way you can use for the Descending order by using keyword DESC

regards

Kamal

Sorting

erichshiino — Tue, 13 Mar 2012 16:59:21 GMT

Hi,

As an alternative, instead of ordering during data load, you can set a default sort order in

Settings -> Document Properties -> Sort

There you can define the default sort order of each of your fields and that will be used in any object you create and include the dimension.

(You can overwrite this default sort order in a specific object in the 'sort ' properties tab

Hope this helps,

Erich