topic Re: Sort Expression in QlikView

Sort Expression

Thu, 21 Mar 2013 11:18:11 GMT

I have a dimension of Name, and this will only ever contain 4 names. It is set in stone.

I do not want to order in alphabetical order, either ascending or descending. I need to order specifically.

e.g. B,A,Z,Y

How can I do this with an expression?

Re: Sort Expression

sushil353 — Thu, 21 Mar 2013 11:23:52 GMT

go to sort tab and in expression:

if(NAME='B',1,if(NAME='A',2,if(NAME='Z',3,4)))

HTH

Sushil

Re: Sort Expression

kaushiknsolanki — Thu, 21 Mar 2013 11:25:09 GMT

Hi,

There are two ways you can do this.

1. Define the sorting in Script :-

Create a table which is link to your table with sort order. Something like below.

Data:

Load Name from Abc;

Sorting:

Load * inline [

Name, Sorting

B,1

A,2

Z,3

Y,4

];

Then in sort window click on the expression and type the field name as Sorting.

2. IN expression it self.

Some thing like this.

if(Name = 'B',1,

if(Name = 'A',2,

if(Name = 'Z',3,

if(Name = 'y',4))))

Hope this is clear.

Regards,

Kaushik Solanki

Re: Sort Expression

Thu, 21 Mar 2013 11:29:02 GMT

use in the sort tab the following expression:

=match(Name,'B','A','Z','Y')

Re: Sort Expression

jagan — Thu, 21 Mar 2013 11:43:54 GMT

Hi,

If you have lot of values then following Koushik's first solution

1. Define the sorting in Script :-

Create a table which is link to your table with sort order. Something like below.

Data:

Load Name from Abc;

Sorting:

Load *

inline [

Name, Sorting

B,1

A,2

Z,3

Y,4

];

Then in sort window click on the expression and type the field name as Sorting.

If you have less values then you can use this

=match(Name,'B','A','Z','Y')

in Sort -> Expression.

Hope this helps you.

Regards,

Jagan.

Re: Sort Expression

Fri, 25 Apr 2014 19:28:19 GMT

Thanks, exactly what I was looking

Re: Sort Expression

Wed, 25 May 2016 05:05:57 GMT

Hi,

I tried all of this but isn't working

if([Pi Py Jan Affluence new]='<100k',1,if([Pi Py Jan Affluence new]='100k-250k',2,if([Pi Py Jan Affluence new]='250k-1M',3,if([Pi Py Jan Affluence new]='1-3M',4,if([Pi Py Jan Affluence new]='3M+',5,if([Pi Py Jan Affluence new]='Established Not New',6,7))))))

I don't understand where I am going wrong. The sorting isn't working and I am using a people chart