topic Re: Order Values in ListBox in QlikView

Order Values in ListBox

Mon, 07 Jul 2014 12:42:00 GMT

Hello,

I have a ListBox where there are the following values:

0<X<2

2<X<4

4<X<6

6<X<8

The thing is that when I show those values, they show differently, and I've tried different ways (Number, Text, Load Order).

Do you know how could I order them?

Thank you!

veidlburkhard — Mon, 07 Jul 2014 12:54:46 GMT

Hi Mart,

Sorting by 'Text' is the right answer see the picture below:

Hope this helps

Burkhard

Mon, 07 Jul 2014 12:57:07 GMT

Thanks! And what if I have the value: X>8? Is there any way to order that one?

Because it appears as the first value when I order them.

veidlburkhard — Mon, 07 Jul 2014 13:11:48 GMT

Hi Mart,

I tested it and it worked well with sorting by 'Text'. See the picture

You should be aware not to have a space in front of the X, though...

Hope this helps

Burkhard

sasikanth — Mon, 07 Jul 2014 13:39:16 GMT

Try to use Match() function in Sort tab--->Expression

lsome thing like

=Match(<Filed-name>,'0<X<2','2<X<4','4<X<6','6<X<8')

Hope it will help