topic Re: Is there a way to capitalize fields values in QlikView

Is there a way to capitalize fields values

Fri, 05 Oct 2012 19:56:43 GMT

Hi,

I have a field country, which the names of the countries in lower case. Is there is a way to capitalize the first letter of the country name in Qlikview?

If yes, how?

Thanks,

Re: Is there a way to capitalize fields values

GabrielAraya — Fri, 05 Oct 2012 19:58:32 GMT

Simple, in the script .. Capitalize(Country) as Country

Gabriel

Re: Is there a way to capitalize fields values

bgerchikov — Fri, 05 Oct 2012 20:01:10 GMT

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

Re: Is there a way to capitalize fields values

Fri, 05 Oct 2012 20:12:39 GMT

Thanks Gabriel for your super fast reply. I got what I was looking for.

Thanks again 🙂

Re: Is there a way to capitalize fields values

Wed, 07 Nov 2012 20:39:32 GMT

Thanks again. As you explained I got what I was looking for but just curious that if I want to capitalize whole word instead of just first letter. How can I do that?

Thanks,

Re: Is there a way to capitalize fields values

MayilVahanan — Wed, 07 Nov 2012 20:45:44 GMT

Use Upper() function

Hope it helps

Re: Is there a way to capitalize fields values

Wed, 07 Nov 2012 21:03:20 GMT

Thanks a lot buddy. I got what I was looking for. I appreciate your quick reply