Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
kicchu465
Contributor

Limit load

hi all,

I want to load only  few of the records from the DB

for example I have  1000 records  but I want to load from db  only 500 records

how to do this?

Thanks

4 Replies
vishsaggi
Esteemed Contributor III

Re: Limit load

Why don't you do like

LOAD *;

SQL

SELECT TOP 500 fieldname1, fieldname2.....

FROM yoursource;

el_aprendiz111
Valued Contributor

Re: Limit load

Hi

1 option

First 1000
LOAD * FROM  [..\..\..\....

Re: Limit load

You have tried this

LOAD

*,

Where Rowno()  <= 1000;

SQL SELECT *

FROM DailyLogTable;

Re: Limit load

For 500 rows this

In SQL

LOAD

*,

Where Rowno()  <= 500;

SQL SELECT *

FROM DailyLogTable;

In Qlikview


1. Way

LOAD

*

Load From SourceTable

Where Rowno()  <= 500;

2. Way

First 500

Load

*

From Source;