Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
Please your help. I have an excel file with many entries, one of them is the date and I need to order them from the oldest to the newest.
Is there any possibility to do this in the script? This because then I need the value order to continue editing.
Best regards
Constanza
Hello @Constanza I think you could achieve this by using order by in your load script. Here are some useful link that could help you solve what you need to achieve:
https://community.qlik.com/t5/QlikView-App-Dev/sort-dates-in-script/td-p/50244
https://community.qlik.com/t5/QlikView-App-Dev/Date-sort-nor-working-in-script/td-p/1125337
If I am not wrong you would need also to specify if you want the order ascending or descending:
Order By FieldName asc;
Hope this could help you!