Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with sorting in list box!

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

Tags (3)
12 Replies
SunilChauhan
Not applicable

Problem with sorting in list box!

properties->sort-> expression->

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

its_anandrjs
Not applicable

Problem with sorting in list box!

Hi,

Use this

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

and paste this code in Sort by expression.

Rgds

Anand

its_anandrjs
Not applicable

Re: Problem with sorting in list box!

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')

Or

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

Rgds

Anand

Not applicable

Problem with sorting in list box!

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?

its_anandrjs
Not applicable

Re: Problem with sorting in list box!

Hi,

You can use this and paste this code in

Properties -> Sort by -> Expresion

=Mid(fieldname,2,2)

Rgds

Anand

its_anandrjs
Not applicable

Re: Problem with sorting in list box!

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

Not applicable

Problem with sorting in list box!

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

its_anandrjs
Not applicable

Re: Problem with sorting in list box!

Hi,

This sorting you are apply on the list box.

Rgds

Anand

SunilChauhan
Not applicable

Problem with sorting in list box!

properties->sort-> expression->

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

state-> ascending