Is there a way to capitalize fields values

[#1]

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,

TA

[GabrielAraya · Accepted solution]

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

BR

Gabriel

[bgerchikov]

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'

[#4]

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

Thanks again 🙂

[#5]

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,

TA

[MayilVahanan]

hi

Use Upper() function

Hope it helps

[#7]

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