topic Changing Script so F becomes Female, M - Male in QlikView

Changing Script so F becomes Female, M - Male

Anonymous — Wed, 08 Feb 2012 07:52:40 GMT

In my ListBox, I want the letter F to show up as Female, M as Male otherwise Unknown.

How do I edit the script to do that. I have an idea, but I'm not sure about everything I need to include.

This is what i'm thinking I need to include. I know I don't have the M, Male included or the unknown.

@30 as Gender (F, Female)

What do I need to add or change about this?

Re: Changing Script so F becomes Female, M - Male

kaushiknsolanki — Wed, 08 Feb 2012 07:56:16 GMT

Hi,

Try as follows.

Load if(Gender = 'M','Male', If(Gender = 'F', 'Female','Unkown')) as Gender_Name

From xyz.

For your case Gender should be replaced by @30

Regards,

Kaushik Solanki

Changing Script so F becomes Female, M - Male

Anonymous — Wed, 08 Feb 2012 08:04:43 GMT

so in the script you sent I should replace Gender with @30?

Such as

Load if(@30 = 'M','Male', If(@30 = 'F', 'Female','Unkown')) as Gender_Name

From xyz.

Changing Script so F becomes Female, M - Male

kaushiknsolanki — Wed, 08 Feb 2012 08:13:19 GMT

Hi,

Yes you are right.

Regards,

Kaushik Solanki

Changing Script so F becomes Female, M - Male

Anonymous — Wed, 08 Feb 2012 08:35:28 GMT

Doesn't seem to be working for me. The Letters F and M haven't changed to Female and Male

Changing Script so F becomes Female, M - Male

eliran — Wed, 08 Feb 2012 08:44:10 GMT

Hi,

Maybe add an example since Kaushik's method is a correct one.

Eliran.

Changing Script so F becomes Female, M - Male

Anonymous — Wed, 08 Feb 2012 08:47:00 GMT

what do you mean by add an example?

Changing Script so F becomes Female, M - Male

kamalqlik — Wed, 08 Feb 2012 08:49:54 GMT

Can you upload your application here ,so we can make changes here.

regards

Kamal

Re: Changing Script so F becomes Female, M - Male

eliran — Wed, 08 Feb 2012 08:52:09 GMT

You can attach a file (qvw) like I'm doing right now.

See the script I have attached.

Hope it helps,

Eliran.

Re: Changing Script so F becomes Female, M - Male

Wed, 08 Feb 2012 10:22:11 GMT

You need to use the new field name rather than the @30 field name. So if you're looking at a list box make sure it's for Gender_Name rather than @30