Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Order by on text and numeric fields

I have a table with 3 columns 1st column contains only text, 2nd column contains only numbers and 3rd column contains text.

I want to sort this table first on column 1 then column 2 in the load script.

I can sort by either of them individually but the following code sorts only on column 1.

load

*

Resident

TABLE

order by Coln1, Coln2;

Thanks

1 Reply
swuehl
MVP
MVP

Can't reproduce it here. Could you upload a small sample that demonstrate your issue?