How to sort data in data load editor and assign order# in Qlik Sense
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.
