Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting

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

1 Solution

Accepted Solutions
erich_shiino
Partner
Partner

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

View solution in original post

4 Replies
CELAMBARASAN
Partner
Partner

Hi,

     Did you tried with Order by Fieldname asc?

     Load

          *

     Resident Table Order By FieldName asc;

     expecting something other than this?

Celambarasan

jagan
MVP
MVP

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
Partner
Partner

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

erich_shiino
Partner
Partner

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

View solution in original post