topic Conversion of string in no in QlikView https://community.qlik.com/t5/QlikView/Conversion-of-string-in-no/m-p/298289#M1182139 <HTML><HEAD></HEAD><BODY><P> Hi Kamal,</P><P></P><P>&nbsp; I couldnt find attachment in your post.</P><P>&nbsp; Try using num function to convert the string into number.</P></BODY></HTML> Sat, 05 Nov 2011 06:11:06 GMT 2011-11-05T06:11:06Z Conversion of string in no https://community.qlik.com/t5/QlikView/Conversion-of-string-in-no/m-p/298288#M1182138 <HTML><HEAD></HEAD><BODY><P>HI friends.....</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am facing a problem while working with the conversion from string to the number format.</P><P>I am fetcing the data from the excel sheet atached below.......but after using cross table...when I want to get the <STRONG>Year field ,<SPAN style="font-family: arial, helvetica, sans-serif;">it is showing me </SPAN></STRONG>in the string format....so that's why I am not able to get the required fields.</P><P></P><P></P><P>Please do the needful</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks </P><P>Kamal</P></BODY></HTML> Sat, 05 Nov 2011 04:41:35 GMT https://community.qlik.com/t5/QlikView/Conversion-of-string-in-no/m-p/298288#M1182138 kamalqlik 2011-11-05T04:41:35Z Conversion of string in no https://community.qlik.com/t5/QlikView/Conversion-of-string-in-no/m-p/298289#M1182139 <HTML><HEAD></HEAD><BODY><P> Hi Kamal,</P><P></P><P>&nbsp; I couldnt find attachment in your post.</P><P>&nbsp; Try using num function to convert the string into number.</P></BODY></HTML> Sat, 05 Nov 2011 06:11:06 GMT https://community.qlik.com/t5/QlikView/Conversion-of-string-in-no/m-p/298289#M1182139 2011-11-05T06:11:06Z