Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
Creator
Creator

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
Champion III
Champion III

Why don't you do like

LOAD *;

SQL

SELECT TOP 500 fieldname1, fieldname2.....

FROM yoursource;

el_aprendiz111
Specialist
Specialist

Hi

1 option

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

its_anandrjs

You have tried this

LOAD

*,

Where Rowno()  <= 1000;

SQL SELECT *

FROM DailyLogTable;

its_anandrjs

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;