topic Re: Limit load in QlikView

Limit load

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

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

vishsaggi — Fri, 27 Oct 2017 16:52:55 GMT

Why don't you do like

LOAD *;

SQL

SELECT TOP 500 fieldname1, fieldname2.....

FROM yoursource;

el_aprendiz111 — Fri, 27 Oct 2017 17:33:46 GMT

1 option

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

its_anandrjs — Fri, 27 Oct 2017 17:41:24 GMT

You have tried this

LOAD

Where Rowno() <= 1000;

SQL SELECT *

FROM DailyLogTable;

its_anandrjs — Fri, 27 Oct 2017 17:44:33 GMT

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;