Sorting a field

[Fergie93]

I have a data set that has been exported from sharepoint to excel. 

one of the fields is a drop down, as an example the data shows with the field as; 

Car;Coffee;Dog

the order can change as well to show as 

Dog;Car;Coffee;None 

 can i within Qlik sort the field to show the options in alphabet order ?

thanks

[vinieme12]

in the properties panel  under "Sorting"

uncheck the highlighted toggle to "Custom"

Then check on Sort Alphabetically

[Fergie93]

Morning. Thank you I should have said looking for a solution in the Data Load Editor rather than in charts 

[vinieme12]

You can using the "Order By" but , the only limitation is that "Order By" only works with Resident Load

Example

temp1:

load * From SomeExcelFile;

NOConcatenate

Main:

Load * Resident temp1

Order by Category ASC;

drop table temp1;

but , how the data is sorted in the model would not make any difference as you can sort the field in visualizations

unless you are making some transformations to the data that needs sorting