Date Order Script

Constanza — Mon, 01 Mar 2021 18:16:31 GMT

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

Re: Date Order Script

Patricia_Silva — Mon, 01 Mar 2021 18:35:42 GMT

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!

topic Re: Date Order Script in QlikView

Date Order Script

Re: Date Order Script