Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

how to limit record load from qvd file

I have a simple load statement that is loading records from a ".qvd" file that has millions of records.

How do I limit my record load to say 1000 records.

Gerry

2 Replies
JonnyPoole
Employee
Employee

Use the First command:

First 1000

Load

     *

from <QVD file>;

its_anandrjs

Hi,

Then try to load like

Load * From a.qvd where

RowNo() <= 1000;  //This loads only 1000 records


Regards

Anand