topic How to convert an integer to a string? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-an-integer-to-a-string/m-p/178720#M45825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to know how to convert a integer to a string so I can concatenate it (with &amp;) to another string.</P><P>More practically, I have a field date coming from my database and from a value of that field, I would like to get "Year-Month".</P><P>So:</P><P>Month(date) -&gt; Oct (as string)</P><P>Year(date) -&gt; 2010 (as integer)</P><P>How do I get: "2010-Oct"?</P><P></P><P>Thank you all</P></BODY></HTML> Fri, 21 Jan 2011 09:42:20 GMT 2011-01-21T09:42:20Z How to convert an integer to a string? https://community.qlik.com/t5/QlikView/How-to-convert-an-integer-to-a-string/m-p/178720#M45825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to know how to convert a integer to a string so I can concatenate it (with &amp;) to another string.</P><P>More practically, I have a field date coming from my database and from a value of that field, I would like to get "Year-Month".</P><P>So:</P><P>Month(date) -&gt; Oct (as string)</P><P>Year(date) -&gt; 2010 (as integer)</P><P>How do I get: "2010-Oct"?</P><P></P><P>Thank you all</P></BODY></HTML> Fri, 21 Jan 2011 09:42:20 GMT https://community.qlik.com/t5/QlikView/How-to-convert-an-integer-to-a-string/m-p/178720#M45825 2011-01-21T09:42:20Z How to convert an integer to a string? https://community.qlik.com/t5/QlikView/How-to-convert-an-integer-to-a-string/m-p/178721#M45826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use year(date)&amp;'-'&amp;Month(date)</P><P>-Sathish</P></BODY></HTML> Fri, 21 Jan 2011 10:01:41 GMT https://community.qlik.com/t5/QlikView/How-to-convert-an-integer-to-a-string/m-p/178721#M45826 sathishkumar_go 2011-01-21T10:01:41Z