I want to migrate an SQL script that is run by VB program on QlikView.
In my result by VB Program, the data are sorted like this 🙂 :
- Umyitem
- Webmyitem
- Zamyitem
- Z@myitem
- Z-myitem
When i run by QlikView, the date are sorted like this 🙄 :
- Umyitem
- Webmyitem
- Z-myitem
- Z@myitem
- Zamyitem
How can i proceed to have the same data with the same order ? I've tried on the sheet Sort on my table Box Properties and i've never change the script SQL
