Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody,
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.
In SQL:
select ID, Name, Store from mytable
order by ID desc
limit 1000
Thx in advance
Hi
Try This Script in Qlikview u get 100 rows
First (100) Select * from IE order by jobno desc;
Regards
Perumal
Hi,
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
First (10)
Select * from Orders
order by ID DESC; (Note: The parenthesis is allowed but not required.)
//Loads first 10 records
First 10
Load * from abc.csv;
Hope this helps you.
Regards,
jagan.