Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
hi
not working
Hi,
Do you want this in expression? then
Try in the Listbox Expression
if(Gender='Male' or Gender='Female', Gender)
Apologies, try this:
if(gender= 'Male' or gender = 'Female',gender,) as Gender
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?
Hi,
Try this
=if(WildMatch(Gender,'MAle','Female'),Gender)
hope it helps.
try,
T1:
LOAD *, if(Lower(trim(Data))='male','Male', if(Lower(trim(Data))='female','Female')) as Gender Inline [
Data
MAle
Female
NA
Ss
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'))