Discussion Board for collaboration related to QlikView App Development.
Can i sort a particular column of the loaded table in .qvw fle in particular order for example say asc or desc??????
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,
View solution in original post
Did you tried with Order by Fieldname asc?
Resident Table Order By FieldName asc;
expecting something other than this?
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.
Order By FieldName ASC;
Order By FieldName DESC;
Hi Manish ,in qlikview thiss can be done by order by.
For example we are having a customer table
Order By CustomerID ASC;
By default qlikview uses ASC
in the same way you can use for the Descending order by using keyword DESC