topic Upper + Fist letter caps in QlikView https://community.qlik.com/t5/QlikView/Upper-Fist-letter-caps/m-p/198329#M57666 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is there a way in Qlikview to change a text to have first letter of every word as Capital</P><P>Eg: "NEW YORK" or "new york" would become "New York"</P><P></P><P>Thanks</P><P>Amit</P></BODY></HTML> Tue, 05 Apr 2011 14:56:43 GMT 2011-04-05T14:56:43Z Upper + Fist letter caps https://community.qlik.com/t5/QlikView/Upper-Fist-letter-caps/m-p/198329#M57666 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is there a way in Qlikview to change a text to have first letter of every word as Capital</P><P>Eg: "NEW YORK" or "new york" would become "New York"</P><P></P><P>Thanks</P><P>Amit</P></BODY></HTML> Tue, 05 Apr 2011 14:56:43 GMT https://community.qlik.com/t5/QlikView/Upper-Fist-letter-caps/m-p/198329#M57666 2011-04-05T14:56:43Z Upper + Fist letter caps https://community.qlik.com/t5/QlikView/Upper-Fist-letter-caps/m-p/198330#M57667 <HTML><HEAD></HEAD><BODY><P>This is the "capitalize" function". So if your field is capital it would be:</P><P></P><P>capitalize([Capital])</P><P></P><P>Should work both in the script and chart expressions.</P><P></P><P>From the QV Reference Manual:</P><P></P><P>capitalize( s )<BR />Returns the string s with all words capitalized.<BR />Examples:<BR />capitalize( 'my little pony' ) returns 'My Little Pony'.<BR />capitalize( 'AA bb cC Dd' ) returns 'Aa Bb Cc Dd'.</P></BODY></HTML> Tue, 05 Apr 2011 15:04:07 GMT https://community.qlik.com/t5/QlikView/Upper-Fist-letter-caps/m-p/198330#M57667 2011-04-05T15:04:07Z