Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Records

Hi Experts,


i have one table like fields YEAR,PRODUCT,SALES .each field have 5 records. When i go for Relode   i want   last 3 records.

How i will  Get the  Last 3 records ?

3 Replies
pamaxeed
Partner - Creator III
Partner - Creator III

You can sort the table in the order you want and use the FIRST prefix:

Like:

First 3 Load *

FROM ....;

Cheers,

Patric

qlikview979
Specialist
Specialist
Author

Can you  Explain  one  Example ?

pamaxeed
Partner - Creator III
Partner - Creator III

Here you are...

Cheers,

Patric