topic Re: Sorting issue in list box in QlikView

Sorting issue in list box

Mon, 25 Nov 2013 10:14:49 GMT

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 — Mon, 25 Nov 2013 10:24:48 GMT

Hi Jaya

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

here i attach qvw files

Mon, 25 Nov 2013 10:30:51 GMT

Hi Jay,

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

Regards

MayilVahanan — Mon, 25 Nov 2013 10:35:17 GMT

PFA

Mon, 25 Nov 2013 10:37:18 GMT

Hi,

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

jagan — Mon, 25 Nov 2013 10:40:18 GMT

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.