i have a listbox wit gender field
wit in dat
like dat so i want seperately male and female
how can i get dat result
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.
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
if(gender = 'MAle' or gender = 'Female' , gender)
Let us know, have you resolved your problem or not?
hope it helps.
LOAD *, if(Lower(trim(Data))='male','Male', if(Lower(trim(Data))='female','Female')) as Gender Inline [
Change the dimesion to an expression in the list box and enter the if condition
Retrieving data ...