TOP X Clause in sentense LOAD

[#1]

I have a question.

In SQL do you have a clasuse TOP X. e.g.

Select TOP 10 Field1 FROM NombreTabla

but in Qlikview yo cant do

Load TOP 10 Field1 FROM NombreArchivoQvd

thanks in advance

Sergio

Saludos!.

[Anonymous]

Not that I'm aware of ... it would be handy though

[#3 · Accepted solution]

You can use the first keyword to limit the number of rows fetched by a load-statement.
You must also order your dataset on the desired field:

first 10 load Field1 FROM NombreArchivoQvd order by Field1;

/Fredrik

[#4]

Thank you so much.