topic TOP X Clause in sentense LOAD in QlikView https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201347#M59488 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Tue, 05 Jan 2010 16:44:39 GMT 2010-01-05T16:44:39Z TOP X Clause in sentense LOAD https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201344#M59485 <HTML><HEAD></HEAD><BODY><P>I have a question.</P><P>In SQL do you have a clasuse TOP X. e.g.</P><P>Select TOP 10 Field1 FROM NombreTabla</P><P>but in Qlikview yo cant do</P><P>Load TOP 10 Field1 FROM NombreArchivoQvd</P><P></P><P>thanks in advance</P><P>Sergio</P><P>Saludos!.</P></BODY></HTML> Tue, 05 Jan 2010 16:06:24 GMT https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201344#M59485 2010-01-05T16:06:24Z TOP X Clause in sentense LOAD https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201345#M59486 <HTML><HEAD></HEAD><BODY><P>Not that I'm aware of ... it would be handy though</P></BODY></HTML> Tue, 05 Jan 2010 16:11:33 GMT https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201345#M59486 Anonymous 2010-01-05T16:11:33Z TOP X Clause in sentense LOAD https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201346#M59487 <HTML><HEAD></HEAD><BODY><P>You can use the <EM>first</EM> keyword to limit the number of rows fetched by a load-statement.<BR />You must also order your dataset on the desired field:</P><P>first 10 load Field1 FROM NombreArchivoQvd order by Field1;</P><P>/Fredrik</P></BODY></HTML> Tue, 05 Jan 2010 16:17:33 GMT https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201346#M59487 2010-01-05T16:17:33Z TOP X Clause in sentense LOAD https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201347#M59488 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Tue, 05 Jan 2010 16:44:39 GMT https://community.qlik.com/t5/QlikView/TOP-X-Clause-in-sentense-LOAD/m-p/201347#M59488 2010-01-05T16:44:39Z