topic Excel file loading? in QlikView https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354957#M825771 <HTML><HEAD></HEAD><BODY><P>How I load an excel table in Qlik view script editor?</P><P>Can anyone help me step by step?</P><P></P><P>Description</P><P></P><P>I had one table in Excel </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE width="471"><TBODY><TR><TD class="xl16" height="28" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #5B9BD5;" width="209">Tesco sales by Branch</TD><TD class="xl16" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #5B9BD5;" width="99">Sales</TD><TD class="xl16" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #5B9BD5;" width="99">Year</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Barking</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">20,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Ilford</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">30,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Gants Hill</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">50,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Deghanam</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">60,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Greenwich</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">70,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">East ham</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">90,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Canning town </TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">100,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Total</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">420,000</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Excel file loading? https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354957#M825771 <HTML><HEAD></HEAD><BODY><P>How I load an excel table in Qlik view script editor?</P><P>Can anyone help me step by step?</P><P></P><P>Description</P><P></P><P>I had one table in Excel </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE width="471"><TBODY><TR><TD class="xl16" height="28" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #5B9BD5;" width="209">Tesco sales by Branch</TD><TD class="xl16" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #5B9BD5;" width="99">Sales</TD><TD class="xl16" style="color: white; font-weight: bold; border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #5B9BD5;" width="99">Year</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Barking</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">20,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Ilford</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">30,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Gants Hill</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">50,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Deghanam</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">60,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Greenwich</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">70,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">East ham</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">90,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Canning town </TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">100,000</TD><TD style="border-top: .5pt solid #9BC2E6; border-right: .5pt solid #9BC2E6; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">2015-16</TD></TR><TR><TD height="20" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: .5pt solid #9BC2E6; background: #DDEBF7;">Total</TD><TD align="right" style="border-top: .5pt solid #9BC2E6; border-right: none; border-bottom: .5pt solid #9BC2E6; border-left: none; background: #DDEBF7;">420,000</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354957#M825771 2020-11-25T16:16:04Z Re: Excel file loading? https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354958#M825772 <HTML><HEAD></HEAD><BODY><P><A href="https://www.tutorialspoint.com/qlikview/qlikview_excel_file.htm" title="https://www.tutorialspoint.com/qlikview/qlikview_excel_file.htm">QlikView Excel Files</A></P></BODY></HTML> Mon, 10 Jul 2017 20:25:49 GMT https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354958#M825772 vamsee 2017-07-10T20:25:49Z Re: Excel file loading? https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354959#M825773 <HTML><HEAD></HEAD><BODY><P>In your edit script use Tables files and open the path of that excel file and click open. It will open a File type wizard. Then select the sheet name and embedded labels as shown in the screen shot. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169704_Capture.PNG" style="height: 212px; width: 620px;" /></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/169705_Capture1.PNG" style="height: 342px; width: 620px;" /></P></BODY></HTML> Mon, 10 Jul 2017 20:39:26 GMT https://community.qlik.com/t5/QlikView/Excel-file-loading/m-p/1354959#M825773 vishsaggi 2017-07-10T20:39:26Z