topic Re: Limit Number of Rows Loaded in QlikView https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194017#M385455 <HTML><HEAD></HEAD><BODY><P>Yes ,</P><P></P><P>Debug option is there to load llimited numer of records</P></BODY></HTML> Thu, 29 Sep 2016 15:34:11 GMT nagarjuna_kotha 2016-09-29T15:34:11Z Limit Number of Rows Loaded https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194015#M385453 <HTML><HEAD></HEAD><BODY><P>Is there a way within the scripting to limit the loading of data to the first 'X' number of rows?</P></BODY></HTML> Thu, 29 Sep 2016 15:28:30 GMT https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194015#M385453 evansabres 2016-09-29T15:28:30Z Re: Limit Number of Rows Loaded https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194016#M385454 <HTML><HEAD></HEAD><BODY><P>There are some ways.</P><P>Load Top 10</P><P></P><P>Or</P><P></P><P>You can write a where statement like</P><P>Load *</P><P>From xyz.qvd where row()&lt;100</P></BODY></HTML> Thu, 29 Sep 2016 15:34:04 GMT https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194016#M385454 rupamjyotidas 2016-09-29T15:34:04Z Re: Limit Number of Rows Loaded https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194017#M385455 <HTML><HEAD></HEAD><BODY><P>Yes ,</P><P></P><P>Debug option is there to load llimited numer of records</P></BODY></HTML> Thu, 29 Sep 2016 15:34:11 GMT https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194017#M385455 nagarjuna_kotha 2016-09-29T15:34:11Z Re: Limit Number of Rows Loaded https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194018#M385456 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>TableName:</STRONG></P><P><STRONG style="color: #ff0000;">First 1000</STRONG></P><P><STRONG>LOAD .....</STRONG></P><P><STRONG>FROM....;</STRONG></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">or</SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>TableName:</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>LOAD ...</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>FROM...</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG><SPAN style="color: #ff0000;">Where RowNo() &lt;= 1000</SPAN>;</STRONG><BR /></SPAN></P></BODY></HTML> Thu, 29 Sep 2016 15:37:17 GMT https://community.qlik.com/t5/QlikView/Limit-Number-of-Rows-Loaded/m-p/1194018#M385456 sunny_talwar 2016-09-29T15:37:17Z