topic Re: Retrieving limited records from database in QlikView

Retrieving limited records from database

Thu, 25 Jul 2013 10:17:13 GMT

Hi All,

How to retrieve limited records from database.

Kindly help me any one.

Thanks in Advance,

Ram.

swuehl — Thu, 25 Jul 2013 10:23:07 GMT

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;

tresB — Thu, 25 Jul 2013 10:25:25 GMT

you can use First like:

First 100

Load * from ...;

this will pull first 100 records from your source