Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Retrieving limited records from database

Hi All,

How to retrieve limited records from database.

Kindly help me any one.

Thanks in Advance,

Ram.

2 Replies
MVP
MVP

Re: Retrieving limited records from database

Not sure if I fully understand, but you can limit the records by using a WHERE clause, like:

SELECT FieldA FROM DB WHERE FieldA > 0;

MVP
MVP

Re: Retrieving limited records from database

you can use First like:

First 100

Load * from ...;

this will pull first 100 records from your source

Community Browser