there are many ways to sort your data...
but if the choices in qlikview sort can't make your requirements
then you can force it by using match function.
go to sort tab > under Expression - set to Ascending
say I have a CATEGORY table with FOOD, MERCHANDIZE, and BEVERAGE as data
using match function I can force it to sort in anyway I want with this syntax
Match(TableName, 'First data', 'Second',...)
in my case:
this will result to
CATEGORY - Table name