Thanks for coming back to me Celambarasan. Its still doesent work. I'm using Qlikview 9, Listbox sort by expression (Asending). Its does not seem to be registering any of my logic as if i change the order in the logic around it dosent move.
My data comes from a datawarehouse (SQL). Would it be anything to do with the data type, i.e. 'Char' length is (20)?
Qv9 doesn't support this.
Then do one thing
Load Dual(StringField,NumField) as FieldName
Then set this dimension in numeric as Ascending order or load order as original;
If your going to use the load order then you should load this table before the that fields gets loaded from someother table.
Hope it helps
Its a separate table.
Load this before the sql table gets executed.
Here i'm using dual field which can act as both text and number in the way u need.so based on this i set the number field to the order that you want.
You can use Finance as Finance and Markering no need to add underscore or any quotes.