Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Jaya
if you want use list box, you can go to tab sort and sort by load order.
here i attach qvw files
Hi Jaya
if you want use list box, you can go to tab sort and sort by load order.
here i attach qvw files
Hi Jay,
You can go for custom sort and give expression some thing like Match(S,F,S&F)
Regards
NR
Hi
PFA
Hi,
After done with some script changes above idea was worked for me. Thank you
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.