topic Re: Upper Case and Lower case in QlikView https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422697#M609039 <HTML><HEAD></HEAD><BODY><P>Thanks...It works but I want First Letter of the fIeld to be capital . How can I do it?</P></BODY></HTML> Mon, 18 Dec 2017 17:45:03 GMT Anonymous 2017-12-18T17:45:03Z Upper Case and Lower case https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422695#M609037 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This is my script. Here, Fields in NAME are displayed in Lower Case and ID in upper case. I want both of them to be displayed as Lower case. How can I do it??</P><P></P><P>"NAME"&amp;'-'&amp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Applymap('MAP',ID) as Location#1,</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 18 Dec 2017 17:32:27 GMT https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422695#M609037 Anonymous 2017-12-18T17:32:27Z Re: Upper Case and Lower case https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422696#M609038 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Lower("NAME"&amp;'-'&amp;Applymap('MAP',ID)) as Location#1,</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 17:35:32 GMT https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422696#M609038 sunny_talwar 2017-12-18T17:35:32Z Re: Upper Case and Lower case https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422697#M609039 <HTML><HEAD></HEAD><BODY><P>Thanks...It works but I want First Letter of the fIeld to be capital . How can I do it?</P></BODY></HTML> Mon, 18 Dec 2017 17:45:03 GMT https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422697#M609039 Anonymous 2017-12-18T17:45:03Z Re: Upper Case and Lower case https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422698#M609040 <HTML><HEAD></HEAD><BODY><P>Try Capitalize then</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Capitalize("NAME"&amp;'-'&amp;Applymap('MAP',ID)) as Location#1,</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 17:46:11 GMT https://community.qlik.com/t5/QlikView/Upper-Case-and-Lower-case/m-p/1422698#M609040 sunny_talwar 2017-12-18T17:46:11Z