topic Loading Excel Files from POS in QlikView https://community.qlik.com/t5/QlikView/Loading-Excel-Files-from-POS/m-p/299026#M1182038 <HTML><HEAD></HEAD><BODY><P> I have a POS system that I can export various data or reports into Excel.&nbsp; I have been able to upload the Excel file into QV without a problem.&nbsp; My challenge is we do about 40000 invoices per year with a lot of data attached.&nbsp; I want to upload the Excel files into QV weekly but do not want to have query the entire time frame (3 years) every time.&nbsp; I would like to just query the last week's numbers and add them to existing database within QV.&nbsp; What is the best way to accomplish this?</P></BODY></HTML> Sun, 06 Nov 2011 14:36:25 GMT 2011-11-06T14:36:25Z Loading Excel Files from POS https://community.qlik.com/t5/QlikView/Loading-Excel-Files-from-POS/m-p/299026#M1182038 <HTML><HEAD></HEAD><BODY><P> I have a POS system that I can export various data or reports into Excel.&nbsp; I have been able to upload the Excel file into QV without a problem.&nbsp; My challenge is we do about 40000 invoices per year with a lot of data attached.&nbsp; I want to upload the Excel files into QV weekly but do not want to have query the entire time frame (3 years) every time.&nbsp; I would like to just query the last week's numbers and add them to existing database within QV.&nbsp; What is the best way to accomplish this?</P></BODY></HTML> Sun, 06 Nov 2011 14:36:25 GMT https://community.qlik.com/t5/QlikView/Loading-Excel-Files-from-POS/m-p/299026#M1182038 2011-11-06T14:36:25Z Loading Excel Files from POS https://community.qlik.com/t5/QlikView/Loading-Excel-Files-from-POS/m-p/299027#M1182039 <HTML><HEAD></HEAD><BODY><P>If I understand you correctly this is called incremental reload. Script just for new records in a partial reload and schedule the partial reload on weekly basis.</P><P></P><P>Kiran.</P></BODY></HTML> Sun, 06 Nov 2011 22:36:06 GMT https://community.qlik.com/t5/QlikView/Loading-Excel-Files-from-POS/m-p/299027#M1182039 2011-11-06T22:36:06Z