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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 ?

Labels (1)
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