topic Sort without using Sort Tab in QlikView

Sort without using Sort Tab

Anonymous — Fri, 13 Jun 2014 07:20:59 GMT

Hello!
I have some table, for ex.

ID Sales

1 30

2 40

3 20

4 5

5 15

6 16

Field 'Sales' is calculated in expression and i need to sort it descending (not using Sort tab, because i'll work with sorted values further)

Thanks for answers!

Gysbert_Wassenaar — Fri, 13 Jun 2014 09:32:21 GMT

The only way to do that is to do the sorting in the load script:

Temp:

Load ID, Sales From ...mysource...;

Result:

Noconcatenate

Load ID, Sales Resident Temp

Order by Sales desc;

Drop Table Temp;

Anonymous — Fri, 13 Jun 2014 09:34:28 GMT

Try like

In the script use Order by function.................