topic Re: sort order(urgent) in QlikView

sort order(urgent)

Wed, 03 Oct 2012 11:58:14 GMT

Hey Guys, i need an urgent help...........

i have a list box, in which i am showing some coloumn and i want to sort the values based on a sort order(Attaching data file for the reference). But, if i am sorting them on the basis of sort order, then the values which doesn't have data is shown at the bottom irrespective of the sort order(attahing image for the reference). How can i solve my problem?

Re: sort order(urgent)

Gysbert_Wassenaar — Wed, 03 Oct 2012 12:03:03 GMT

On the Sort tab unselect Sort by State

Re: sort order(urgent)

Wed, 03 Oct 2012 12:05:04 GMT

I want my list box to look like this:

Re: sort order(urgent)

Wed, 03 Oct 2012 12:13:30 GMT

Hey Gwassenar, i did that but there is no change in the sorting of the list box......

Re: sort order(urgent)

Anonymous — Wed, 03 Oct 2012 12:21:21 GMT

I've not managed to replicate your image exactly, but assume the following:

1. you have all the data fields are selected ?

2. you are have ticked Expression and set up [sort order] as the expression

3. you have unticked the State sort order.

I've not managed to get it perfect either, but strangley have found that ticking Text with A->Z enables these excluded options to move from the end of the list (see attached). Not sure what is happening there.

Regards,

Jonathan

Re: sort order(urgent)

Wed, 03 Oct 2012 12:24:00 GMT

Hey shivaraj.......i tried that too but it is not working.....

Re: sort order(urgent)

flipside — Wed, 03 Oct 2012 12:58:52 GMT

I have used the following approach to force bespoke sorting.

data:
load * inline [
Name, sort
PE,12
UNASGPRVC,0
BC,1
NATIONAL,-1
YT,2
NU,5
SK,6
NL,10
MB,7
NT,3
AB,4
ON,8
QC,9
NB,11
NS,13];

set delim = chr(39) & ',' & chr(39);

sortOrders:
LOAD
chr(39) & concat(Name,$(delim),sort) & chr(39) as NameSort
resident data;

vNameSort = peek('NameSort');

It basically creates a concatenated list and places it into a variable which you can then use in your sort list by checking only Expression =$(vNameSort).

flipside