RE:listbox

[Chanty4u]

Hi,guys

i have a listbox wit gender field

wit in dat

i have

MAle

Female

NA

Ss

like dat  so i want seperately male and female

how can i get dat result

tjank you

Suresh

[vardhancse]

so in list box you want only male and female, if so in list box->select expression instead of field.

give condition if(gender='Male', or 'Female', gender)

[Anonymous]

Alternatively apply the same expression in the script and create a new Field:

if(gender='Male', or 'Female', gender) as Gender

And use this in your list box instead, which would be useful if you plan to re-use.

[Chanty4u]

hi

not working

[settu_periasamy]

Hi,

Do you want this in expression? then

Try in the Listbox Expression

if(Gender='Male' or Gender='Female', Gender)

[Anonymous]

Apologies, try this:

if(gender= 'Male' or gender = 'Female',gender,) as Gender

[tyagishaila]

Go to List box properties--> select expression

write expression

if(gender = 'MAle' or gender = 'Female' , gender)

Let us know, have you resolved your problem or not?

[krishna20]

Hi,

Try this

=if(WildMatch(Gender,'MAle','Female'),Gender)

hope it helps.

[Kushal_Chawda]

try,

T1:

LOAD *, if(Lower(trim(Data))='male','Male', if(Lower(trim(Data))='female','Female')) as Gender Inline [

Data

MAle

Female

NA

Ss

[sasiparupudi1]

Change the dimesion to an expression in the list box and enter the if condition

=if(lower(Gender)='male','Male',if (lower(Gender)='female','Female'))