topic Re: Loading with Multiple Excel Sheets in QlikView https://community.qlik.com/t5/QlikView/Loading-with-Multiple-Excel-Sheets/m-p/515203#M192393 <HTML><HEAD></HEAD><BODY><P>Now I am using auto load</P></BODY></HTML> Wed, 15 Jan 2014 06:40:48 GMT 2014-01-15T06:40:48Z Loading with Multiple Excel Sheets https://community.qlik.com/t5/QlikView/Loading-with-Multiple-Excel-Sheets/m-p/515202#M192392 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>&nbsp;&nbsp; I have excel sheet with different name that is like 2013oct3,2013oct4. I have loaded script like given below. Now i am facing the problem is if the excel sheet is wrongly copied by the user. that value is also calculating. how to i calculate the value which is single. if i give distinct Expression as Sum(Distinct Total) . it showing wrong value. Please give me the solution ASP</P><P></P><P>Load</P><P>Filename() as filename,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(date#(mid(Filename(),18,8),'YYYYMMDD'),'DD-MM-YYYY')&nbsp; as orderdate, .. ..</P><P>From /*.CSV. </P></BODY></HTML> Sat, 05 Oct 2013 04:54:30 GMT https://community.qlik.com/t5/QlikView/Loading-with-Multiple-Excel-Sheets/m-p/515202#M192392 2013-10-05T04:54:30Z Re: Loading with Multiple Excel Sheets https://community.qlik.com/t5/QlikView/Loading-with-Multiple-Excel-Sheets/m-p/515203#M192393 <HTML><HEAD></HEAD><BODY><P>Now I am using auto load</P></BODY></HTML> Wed, 15 Jan 2014 06:40:48 GMT https://community.qlik.com/t5/QlikView/Loading-with-Multiple-Excel-Sheets/m-p/515203#M192393 2014-01-15T06:40:48Z