topic Re: Import excel sheet in QlikView https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048337#M923816 <HTML><HEAD></HEAD><BODY><P>LOAD Number, Date, Group</P><P>FROM YourFile</P><P>WHERE Number like 'IN*';</P></BODY></HTML> Mon, 18 Apr 2016 09:41:07 GMT swuehl 2016-04-18T09:41:07Z Import excel sheet https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048336#M923815 <HTML><HEAD></HEAD><BODY><P>So I am importing an excel sheet.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group</STRONG></TH></TR><TR><TD style="padding: 2px;">IN1234</TD><TD style="padding: 2px;">17/04/2016</TD><TD style="padding: 2px;">X</TD></TR><TR><TD style="padding: 2px;">IN12345</TD><TD style="padding: 2px;">18/04/2016</TD><TD style="padding: 2px;">Y</TD></TR><TR><TD style="padding: 2px;">IN123456</TD><TD style="padding: 2px;">19/04/2016</TD><TD style="padding: 2px;">Z</TD></TR></TBODY></TABLE><P><BR />Total: 3; Created 19/04/2016</P><P></P><P>Imagine the above is exported from excel including the text Total 3 ......</P><P></P><P>I don't ever want the text Total .... to appear. Is there a way for Qlikview to remove this so I only have the Number column with IN#'s?</P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048336#M923815 bobbydave 2020-11-25T16:16:04Z Re: Import excel sheet https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048337#M923816 <HTML><HEAD></HEAD><BODY><P>LOAD Number, Date, Group</P><P>FROM YourFile</P><P>WHERE Number like 'IN*';</P></BODY></HTML> Mon, 18 Apr 2016 09:41:07 GMT https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048337#M923816 swuehl 2016-04-18T09:41:07Z Re: Import excel sheet https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048338#M923817 <HTML><HEAD></HEAD><BODY><P>While loading the data from Excel, after selecting the file you have a step "enable transformation" which you will get after selecting next rather than finish, there you can select the necessary data, if you have limited data to select , otherwise you can go with Swuehl method. </P></BODY></HTML> Mon, 18 Apr 2016 09:49:31 GMT https://community.qlik.com/t5/QlikView/Import-excel-sheet/m-p/1048338#M923817 kkkumar82 2016-04-18T09:49:31Z