Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data load

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.

1 Reply
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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;