Data load

Sun, 17 Feb 2013 16:23:54 GMT

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.

Re: Data load

phaneendra_kunc — Sun, 17 Feb 2013 18:47:23 GMT

Never knew that feature in Qlikview except below...

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

But you can use SQL statements ...

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

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