topic Re: Sort on names from A-Z in QlikView

Sort on names from A-Z

Wed, 22 May 2013 17:11:05 GMT

Can we sort on the names from A-Z in the script?

Re: Sort on names from A-Z

MayilVahanan — Wed, 22 May 2013 17:13:34 GMT

Try with "Order by"

Load * from tablename

Order by Name;

Hope it helps

Re: Sort on names from A-Z

Wed, 22 May 2013 17:19:18 GMT

Hi, i have the dataset about couple of hundred thousand records using the "Order by" might get me the order thats needed, but i am worried about the script execution time do you think it might affect the execution time i know for sure that "groub by" does affect the execution time?

Re: Sort on names from A-Z

Gysbert_Wassenaar — Wed, 22 May 2013 17:35:13 GMT

It does affect execution time but with a hundred thousand records that shouldn't make much difference. First you have to load the data into a table and then do another resident load to sort the data:

Temp:

load * from sometable;

Result:

load * resident Temp

order by Name;

If you get your data from a database you can have the database sort the data for you:

Result:

SQL select * from sometable

order by Name;

The database will also need time to sort the data, but it may be faster. You'll have to test which option is the optimal solution.