topic Re: How ignore some sheet? in QlikView https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793940#M661259 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How are you loading all the sheet of workbook?</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Thu, 26 Feb 2015 11:11:11 GMT jyothish8807 2015-02-26T11:11:11Z How ignore some sheet? https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793939#M661258 <HTML><HEAD></HEAD><BODY><P>I received xls files, and these files have many sheets. Last sheet in file is incorrect. How ignore this sheet?</P></BODY></HTML> Thu, 26 Feb 2015 11:09:41 GMT https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793939#M661258 vchuprina 2015-02-26T11:09:41Z Re: How ignore some sheet? https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793940#M661259 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How are you loading all the sheet of workbook?</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Thu, 26 Feb 2015 11:11:11 GMT https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793940#M661259 jyothish8807 2015-02-26T11:11:11Z Re: How ignore some sheet? https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793941#M661260 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>go through this:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4452">http://community.qlik.com/docs/DOC-4452</A></P><P></P><P>In this simply ignore the last sheet from the loop and try to number your sheets as 1,2,3.....</P><P></P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Thu, 26 Feb 2015 11:20:06 GMT https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793941#M661260 jyothish8807 2015-02-26T11:20:06Z Re: How ignore some sheet? https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793942#M661261 <HTML><HEAD></HEAD><BODY><P>I use following loop</P><P></P><P>FOR j=0 TO NoOfRows('tables')-1</P><P>.</P><P>.</P><P>.</P><P>.</P><P>Next j</P></BODY></HTML> Thu, 26 Feb 2015 14:05:11 GMT https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793942#M661261 vchuprina 2015-02-26T14:05:11Z Re: How ignore some sheet? https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793943#M661262 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Simply make it :</P><P>FOR j=0 TO NoOfRows('tables')-2</P><P>.</P><P>.</P><P>.</P><P>.</P><P>Next j</P><P></P><P></P><P>So it will ignore the last sheet. give it a try.</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Fri, 27 Feb 2015 04:48:00 GMT https://community.qlik.com/t5/QlikView/How-ignore-some-sheet/m-p/793943#M661262 jyothish8807 2015-02-27T04:48:00Z