Sorting issue in list box

[#1]

Hi All,

  I am having the table on following structure. There is some issue in the sorting the values in the list box

S_Filtr,F_Filtr

1,0

0,1

1,1

IF(S_Filtr=1 AND F_Filtr=1,'S&F',if(S_Filtr=1,'S Only',IF(F_Filtr=1,'F Only','N/A'))) As Type

I need to show the list box values in the following manner

1. S Only

2. F Only

3. S & F

How to achieve this

-Jay

[marcohadiyanto · Accepted solution]

Hi Jaya

if you want use list box, you can go to tab sort and sort by load order.

here i attach qvw files

[#3]

Hi Jay,

You can go for custom sort and give expression some thing like Match(S,F,S&F)

Regards

NR

[MayilVahanan]

Hi

PFA

[#5]

Hi,

  After done with some script changes above idea was worked for me. Thank you

[jagan]

Hi,

Try like this

Data:

LOAD *,

IF(S_Filtr=1 AND F_Filtr=1,Dual('S&F', 3),if(S_Filtr=1, Dual('S Only', 1), IF(F_Filtr=1, Dual('F Only', 2), Dual('N/A', 4)))) As Type

INLINE [

S_Filtr,F_Filtr

1,0

0,1

1,1 ];

Now in list box Properties -> Sort Tab -> Select Number

Hope this helps you.

Regards,

Jagan.