How to sort data in data load editor and assign order# in Qlik Sense

[#1]

Hi experts,

I already have a table like below:

Item	Rate1	Rate2
A	1.4	2.4
B	9.1	0
C	4.8	7.8
D	10.5	1.1
E	8	3.5
F	3.9	8.2
G	0.8	5.3
AA	6.2	0
BB	5	6
CC	7.4	0
DD	2.9	4
EE	0	0

The ITEM could be ignored. I would like to sort the two fields separately and then assign order# from largest to smallest:

Order#	Rate1	Rate2
1	10.5	8.2
2	9.1	7.8
3	8	6
4	7.4	5.3
5	6.2	4
6	5	3.5
7	4.8	2.4
8	3.9	1.1
9	2.9	0
10	1.4	0
11	0.8	0
12	0	0

Please let me know if it is doable. If yes, how?

I am actually looking for a multiple line chart without dimension(Basically draw sorted Rate1 and Rate2 in a line chart), but I cannot find a solution, so I come up with this workaround. If you also know how to draw lines without dimension, please let me know as well.

Thanks,

Jing

[swuehl · Accepted solution]

Maybe using this script:

SORTED:

LOAD Rate1, Recno() as [Order#]

RESIDENT YourTable

ORDER BY Rate1 DESC;

JOIN (SORTED)

LOAD Rate2, Recno() as [Order#]

RESIDENT YourTable

ORDER BY Rate2 DESC;

DROP TABLE YourTable;

[#3]

This works perfectly! Thanks a lot Swuehl!