Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

sort alphabetically characters within a field

is it possible, in the process of loading data, sort alphabetically characters within a field (alphanumeric)?

12 Replies
Highlighted
Specialist III
Specialist III

Honestly speaking, this solution is the best & master class.

you're sunny right sunny. But, I've a question here - How does Alpha numeric gets sorted out. Numbers can be sorted in ascending or descending order. But, how to do that with Alphabets. I've tried the solution with customized strings and it's not giving the desired output. I'll try & come back with modified solution.

Sunny, if I'm missing something than please correct me. I came here for the basics & concepts clarity.

 

Highlighted
Specialist III
Specialist III

Perfect Solution & Master Class...........!!

Highlighted
Specialist III
Specialist III

Even my brain got jammed... I'm not able to figure out the sorting part that how does it sorted the Alphanumeric string using Order By which is meant for the Number values.