topic Re: Problems with excel and cross table in QlikView https://community.qlik.com/t5/QlikView/Problems-with-excel-and-cross-table/m-p/1329223#M838919 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>tabla:</STRONG></P><P><STRONG>NoConcatenate</STRONG></P><P><STRONG>LOAD <SPAN style="color: #ff0000;">Date(Num#(</SPAN>Fecha<SPAN style="color: #ff0000;">))</SPAN> AS DATE,</STRONG></P><P><STRONG>&nbsp; Monto AS MONEY</STRONG></P><P><STRONG>resident tmp;</STRONG></P><P><STRONG>drop table tmp;</STRONG></P></BODY></HTML> Thu, 11 May 2017 15:44:19 GMT sunny_talwar 2017-05-11T15:44:19Z Problems with excel and cross table https://community.qlik.com/t5/QlikView/Problems-with-excel-and-cross-table/m-p/1329222#M838918 <HTML><HEAD></HEAD><BODY><P>Hello is the first time that this is happening</P><P></P><P>I do a cross table and qvw is taking the date from excel as text and i can't change it</P><P></P><P>I'll put qvw and xls here</P><P></P><P>Thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problems-with-excel-and-cross-table/m-p/1329222#M838918 2020-11-25T16:16:04Z Re: Problems with excel and cross table https://community.qlik.com/t5/QlikView/Problems-with-excel-and-cross-table/m-p/1329223#M838919 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>tabla:</STRONG></P><P><STRONG>NoConcatenate</STRONG></P><P><STRONG>LOAD <SPAN style="color: #ff0000;">Date(Num#(</SPAN>Fecha<SPAN style="color: #ff0000;">))</SPAN> AS DATE,</STRONG></P><P><STRONG>&nbsp; Monto AS MONEY</STRONG></P><P><STRONG>resident tmp;</STRONG></P><P><STRONG>drop table tmp;</STRONG></P></BODY></HTML> Thu, 11 May 2017 15:44:19 GMT https://community.qlik.com/t5/QlikView/Problems-with-excel-and-cross-table/m-p/1329223#M838919 sunny_talwar 2017-05-11T15:44:19Z