Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

andreyfcdk91
New Contributor III

Sort without using Sort Tab

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!

Tags (1)
1 Solution

Accepted Solutions

Re: Sort without using Sort Tab

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;


talk is cheap, supply exceeds demand
2 Replies

Re: Sort without using Sort Tab

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;


talk is cheap, supply exceeds demand
venkatasreekant
Valued Contributor

Re: Sort without using Sort Tab

Try like

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

Community Browser