How to sort the text and numeric values in the ascending order in straight table in qlikview

[Ramya]

Hi,

I need to sort one dimension in Straight table which contains both numeric values and text values in a way like numeric values should be starting in the st table followed by text values in the ascending order.

I have used the options in the sort both Text (ascending) and numeric values(ascending) but it is not working.

when i am trying to sort only the text in ascending order i am getting the numeric values first and then it is sorting by ascending order text values also but after X i am getting again the values which i have highlighted in yellow in the attched document.

Can anyone please help me here.

[AdiPai]

You could use the dual function in this case and configure the dimensions to be sorted the way you need

[Frank_Hartmann]

maybe like this:

tmp:
Load *, left([Business Process],1) as Sort;
LOAD [Business Process] , 
     [Total Cases], 
     Blocked, 
     F4, 
     F5, 
     F6, 
     F7, 
     F8, 
     F9, 
     F10, 
     F11, 
     F12, 
     F13, 
     F14
FROM
[sorting.xlsx]
(ooxml, embedded labels, table is Sheet1);

left join Load Sort, [Business Process] Resident tmp Order by Sort asc; //DROP Table tmp;