Upper + Fist letter caps

[#1]

Hi

Is there a way in Qlikview to change a text to have first letter of every word as Capital

Eg: "NEW YORK" or "new york" would become "New York"

Thanks

Amit

[#2 · Accepted solution]

This is the "capitalize" function". So if your field is capital it would be:

capitalize([Capital])

Should work both in the script and chart expressions.

From the QV Reference Manual:

capitalize( s )
Returns the string s with all words capitalized.
Examples:
capitalize( 'my little pony' ) returns 'My Little Pony'.
capitalize( 'AA bb cC Dd' ) returns 'Aa Bb Cc Dd'.