topic Re: Custom sorting in QlikView

Custom sorting

Tue, 24 Sep 2013 11:13:16 GMT

Hi,

I have this column that consists of the given set of values

I want it to be sorted as

0

1

2

3

4-7

8-15

16-30

31-60

60+

How to do this? Please help

Re: Custom sorting

yavoro — Tue, 24 Sep 2013 14:11:00 GMT

I would use match function, so your sort order condition should be something like:

match(columnName,'0','1','2','3','4-7','8-15','16-30','31-60','60+')

Give it a try

Cheers

Re: Custom sorting

MayilVahanan — Tue, 24 Sep 2013 14:35:59 GMT

HI

Try with dual function in script itself.

or

match(columnName,'0','1','2','3','4-7','8-15','16-30','31-60','60+') in sort expression

Re: Custom sorting

Clever_Anjos — Tue, 24 Sep 2013 14:53:00 GMT

Use a dual, example below:

LOAD dual(F1,RowNo()) as F1 INLINE [

F1

0

1

2

3

4-7

8-15

16-30

31-60

60+

];