topic Problem with sorting in list box! in QlikView

Problem with sorting in list box!

Thu, 29 Sep 2011 11:51:45 GMT

Hi All

I have given the scenario below.

Before using the expression in one of my list box it was displaying as shown below which was expected.

A A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12

As I wanted to filter A from above list box. I used the expression as if(fieldname<>A,fieldname)

A1 A10 A11 A12 A2 A3 A4 A5 A6 A7 A8 A9

May I know how to sort that so that it displays as expected(Shown below).

Thanks

Attitude

Problem with sorting in list box!

SunilChauhan — Thu, 29 Sep 2011 11:57:37 GMT

properties->sort-> expression->

wildmatch(col,'A1', 'A10' ,'A11', 'A12', 'A2' ,'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9')

Problem with sorting in list box!

its_anandrjs — Thu, 29 Sep 2011 11:59:36 GMT

Hi,

Use this

Mid(YourField,2,Len(Yourfield)-1)

and paste this code in Sort by expression.

Rgds

Anand

Re: Problem with sorting in list box!

its_anandrjs — Thu, 29 Sep 2011 12:02:29 GMT

Hi,

Or in place of that you may use

Properties -> Sort by -> Expresion

Match(col,'A1', 'A2' ,'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9','A10' ,'A11', 'A12')

Mid(YourField,2,Len(Yourfield)-1)

Rgds

Anand

Problem with sorting in list box!

Thu, 29 Sep 2011 12:05:57 GMT

Thanks!

Yes I did that before. But I have somewhere that it can be achieved without the use of wlidmatch? Any guesses???

So can it be achieved without the use of wildmatch?

Re: Problem with sorting in list box!

its_anandrjs — Thu, 29 Sep 2011 12:09:55 GMT

Hi,

You can use this and paste this code in

Properties -> Sort by -> Expresion

=Mid(fieldname,2,2)

Rgds

Anand

Re: Problem with sorting in list box!

its_anandrjs — Thu, 29 Sep 2011 12:17:01 GMT

Hi,

If you want to filter A from list use

=If ( Len( fieldname ) > 1 , fieldname )

And to sort use

Properties -> Sort by -> Expresion

=Mid(fieldname,2,2)

Rgds

Anand

Problem with sorting in list box!

Thu, 29 Sep 2011 12:22:38 GMT

Hi All

wildmatch --> Not sorting properly when related values are not there in the list box which is relation to the selection.

Mid(YourField,2,Len(Yourfield)-1) --> Not sorting properly when related values are not there in the list box which is relation to the selection.

Mid(fieldname,2,2) --> Not working as expected!

Thanks

Attitude

Re: Problem with sorting in list box!

its_anandrjs — Thu, 29 Sep 2011 12:29:53 GMT

Hi,

This sorting you are apply on the list box.

Rgds

Anand

Problem with sorting in list box!

SunilChauhan — Thu, 29 Sep 2011 12:55:58 GMT

properties->sort-> expression->

wildmatch(col,'A1', 'A10' ,'A11', 'A12', 'A2' ,'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9')

state-> ascending

Problem with sorting in list box!

Thu, 29 Sep 2011 18:58:44 GMT

Hope you are looking for the sort order

A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12

properties->sort-> expression->ascending

Give the expression as

=Replace(fieldname,'A','')

I think this would work out. Not sure if there is a better way ..

Regards

Problem with sorting in list box!

its_anandrjs — Sat, 01 Oct 2011 20:11:52 GMT

Hi,

Hope you got any solution if not let me know about that or share any sample file.

Rgds

Anand

Re: Problem with sorting in list box!

kaushiknsolanki — Mon, 03 Oct 2011 14:12:59 GMT

Hi,

Have a look at the example file.

Regards,

Kaushik Solanki