Discussion Board for collaboration related to Creating Analytics for QlikView.
it is possible to get only the last 1000 entries?
In QV I just found the function FIRST (FIRST 1000 entries).
For testing for me is fine when I get my last 1000 entries.
select ID, Name, Store from mytable
order by ID desc
Thx in advance
Try This Script in Qlikview u get 100 rows
First (100) Select * from IE order by jobno desc;
There is no such option to retrieve last n number of rows. There is only option for first n number of rows. To retrieve last rows then you need to use order by desc.
//Loads last 10 records
Select * from Orders
order by ID DESC; (Note: The parenthesis is allowed but not required.)
//Loads first 10 records
Load * from abc.csv;
Hope this helps you.