topic Re: RE:listbox in QlikView

RE:listbox

Chanty4u — Wed, 08 Jul 2015 11:13:45 GMT

Hi,guys

i have a listbox wit gender field

wit in dat

i have

MAle

Female

like dat so i want seperately male and female

how can i get dat result

tjank you

Suresh

Re: RE:listbox

vardhancse — Wed, 08 Jul 2015 11:16:29 GMT

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)

Re: RE:listbox

Anonymous — Wed, 08 Jul 2015 11:20:36 GMT

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.

Re: RE:listbox

Chanty4u — Wed, 08 Jul 2015 11:28:41 GMT

not working

Re: RE:listbox

settu_periasamy — Wed, 08 Jul 2015 11:32:02 GMT

Hi,

Do you want this in expression? then

Try in the Listbox Expression

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

Re: RE:listbox

Anonymous — Wed, 08 Jul 2015 11:37:33 GMT

Apologies, try this:

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

Re: RE:listbox

tyagishaila — Wed, 08 Jul 2015 12:13:16 GMT

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?

Re: RE:listbox

krishna20 — Wed, 08 Jul 2015 12:18:39 GMT

Hi,

Try this

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

hope it helps.

Re: RE:listbox

Kushal_Chawda — Wed, 08 Jul 2015 12:30:26 GMT

try,

T1:

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

Data

MAle

Female

Re: RE:listbox

sasiparupudi1 — Wed, 08 Jul 2015 12:57:08 GMT

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'))