Data load

[#1]

i want to load table frm data base into qlikview but i want to load from row no 1000 to row 4000 data only into qlikview.

Please update me how to do this at time of loading.

[phaneendra_kunc]

Never knew that feature in Qlikview except below...

Add this before your Load statement ...."First 1000"

But you can use SQL statements ...

http://stackoverflow.com/questions/1891789/sql-select-first-10-rows-only

Oracle: WHERE ROWNUM >= 1000  and ROWNUM <= 4000 ;

My SQL: SELECT * FROM `table` LIMIT 1000, 4000;