topic QV does not read num posts from Excel in QlikView https://community.qlik.com/t5/QlikView/QV-does-not-read-num-posts-from-Excel/m-p/809790#M285826 <HTML><HEAD></HEAD><BODY><P>I read an Excel in this format. The first field have text strings on some rows and all numbers in others.</P><P></P><P>12515305616<STRONG>Q</STRONG>85360&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.04.08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015-02-11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:53:19<BR />12514257614185300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08.04.08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015-02-11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:27:09</P><P></P><P>The fields that contain a letter is read but not the fields that are all numbers.</P><P>If I use Num() the number fields show up but not the letter fields. Text() makes no difference.</P><P>Tried to add a '¤' in front of the string and read the source resident. Same result.</P><P></P><P> Probably some easy fix, right?</P></BODY></HTML> Mon, 16 Feb 2015 10:16:07 GMT 2015-02-16T10:16:07Z QV does not read num posts from Excel https://community.qlik.com/t5/QlikView/QV-does-not-read-num-posts-from-Excel/m-p/809790#M285826 <HTML><HEAD></HEAD><BODY><P>I read an Excel in this format. The first field have text strings on some rows and all numbers in others.</P><P></P><P>12515305616<STRONG>Q</STRONG>85360&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.04.08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015-02-11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:53:19<BR />12514257614185300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08.04.08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015-02-11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:27:09</P><P></P><P>The fields that contain a letter is read but not the fields that are all numbers.</P><P>If I use Num() the number fields show up but not the letter fields. Text() makes no difference.</P><P>Tried to add a '¤' in front of the string and read the source resident. Same result.</P><P></P><P> Probably some easy fix, right?</P></BODY></HTML> Mon, 16 Feb 2015 10:16:07 GMT https://community.qlik.com/t5/QlikView/QV-does-not-read-num-posts-from-Excel/m-p/809790#M285826 2015-02-16T10:16:07Z Re: QV does not read num posts from Excel https://community.qlik.com/t5/QlikView/QV-does-not-read-num-posts-from-Excel/m-p/809791#M285827 <HTML><HEAD></HEAD><BODY><P>The text() function should work. But try using the evaluate() function. If that doesn't give you the results you want could you post an excel file with some example data?</P></BODY></HTML> Mon, 16 Feb 2015 10:25:59 GMT https://community.qlik.com/t5/QlikView/QV-does-not-read-num-posts-from-Excel/m-p/809791#M285827 Gysbert_Wassenaar 2015-02-16T10:25:59Z