Sorting

[#1]

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

[CELAMBARASAN]

Hi,

     Did you tried with Order by Fieldname asc?

     Load

          *

     Resident Table Order By FieldName asc;

     expecting something other than this?

Celambarasan

[jagan]

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.

[kamalqlik]

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

[erichshiino · Accepted solution]

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